We couldn’t sign you in
Select the account you want to use.


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.


To resolve this issue, follow these steps. 

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:


  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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!