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.
- On the Tools menu, click Options.
- On the International tab, under Number Handling, clear the Use system separators check box.
- 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.
United States
Email this link
Printer-Friendly Version
Share
