Change the separator for thousands and decimals

By default, Microsoft Excel uses the system separators that are defined in the regional settings in Control Panel. If you sometimes need to display numbers with different separators for thousands or decimals, you can temporarily replace the system separators with custom separators.

  1. On the Tools menu, click Options.
  2. On the International tab, under Number Handling, clear the Use system separators check box.
  3. Type new separators in the Decimal separator and Thousands separator boxes.

Tip    When you want to use the system separators again, select the the Use system separators check box.

 Note   For a permanent solution, you must change the regional settings. For more information, see Change the default country/region.

 
 
Applies to:
Excel 2003