Escel 2003 Comma Style on Toolbar will not work

[lmahaffey]

When I click on the comma style icon the formats change to dollar sign. I am
using a spreadsheet someone else created. How can I make the comma icon work?

 

[Gord Dibben]

Format>Style>Style Name>Comma

Make the necessary modifications.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Another way is to merge the style from a workbook where it does work.

Open the "bad" workbook.
Start a new workbook.
Make sure the comma icon works ok in the new workbook.

Activate the bad workbook.
Format|Style|Click the Merge button
choose the new workbook (book1)

Remember to save the troublesome workbook after you're done.