Excel Decimal Symbol

M

Machado

I need to produce spreadsheet files according to
Continental and English rules relating to decimal
symbol/digit grouping symbol.
So, according to the end-users, I need to change the
decimal symbol from comma to point and the digit grouping
symbol from point to comma. Is it possible (e.g. by using
custom number formats) to change the appearance of the
numbers to reflect the different rules, without having to
change the regional settings?

Thanks,
 
J

Jim Rech

Excel is designed to automatically format numbers according to the user's
Regional Settings.

For instance, if I see this with my U.S. settings:

1,234.00

and then change to say, German settings, I see this:

1.234,00
 
Top