Escel 2003 Comma Style on Toolbar will not work

  • Thread starter Thread starter lmahaffey
  • Start date Start date
L

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?
 
Format>Style>Style Name>Comma

Make the necessary modifications.


Gord Dibben MS Excel MVP
 
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.
 
Back
Top