Excel Decimal Symbol

  • Thread starter Thread starter Machado
  • Start date Start date
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,
 
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
 
Back
Top