View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Formatting numbers

This is a matter of regional settings. Either change your Windows system
settings or for one workbook you can override them (in Excel2003) by
ToolsOptionsInternational tab (I'm translating back to English, the name
may be different, it's located between Color and Save tabs), uncheck system
settings and enter desired characters in decimal separator and thousands
separator field.

Regards,
Stefi

€žAruna€ť ezt Ă*rta:

Change format of numbers. For example, from 20.566,70 to 20,566.70