Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Custom decimal and thousand separators are not applied in Excel 2010

Custom decimal and thousand separators are not applied in Excel 2010

View products that this article applies to.

Symptoms

Assume that you configure custom decimal and thousand separators in Microsoft Excel 2010. When you open a workbook that contains a chart, numbers in the chart are formatted incorrectly.

↑ Back to the top

Resolution

To resolve this issue, follow these steps. 

Important
Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then select the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common\Charting
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type ApplyCustomSeparatorToPicFmt, and then press Enter.
  5. In the Details pane, right-click ApplyCustomSeparatorToPicFmt, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.
  8. Restart Excel 2010, and then open the workbook again.
Note If you set the value of the registry key to 0 or delete the registry key, the custom separators are not applied in Excel 2010.

↑ Back to the top

Keywords: kbsurveynew, kbbug, kbfix, kbexpertisebeginner, kbtshoot, kb

↑ Back to the top

Article Info
Article ID : 2844303
Revision : 1
Created on : 1/7/2017
Published on : 7/23/2013
Exists online : False
Views : 215