pivot table

folliet sebastien

Hi

I'm trying to use the pivot table but impossible to find the thousands separator.
You can find in the attach file my configuration.
What are the configuration to view the thousands separator?,Is it possible whit the pivot table?

Sincerely

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/sebastien/thousand separator.JPG]thousand separator.JPG[/url]

Massimo Sommaruga

Hi Sebastien,
try with

#,##0.00

, (comma) is the thousand separator
while . (dot) is the decimal placeholder

Hope it works!

Regards.

Massimo

folliet sebastien

Hi Massimo
Is it possible to have the result of this form :2'000.00 .
with your solution we obtains this: 2,000.00