Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Change the character used to separate thousands or 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.

advertisement