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?

FormatStyleStyle NameComma

Make the necessary modifications.


Gord Dibben MS Excel MVP

On Thu, 19 Mar 2009 12:39:01 -0700, lmahaffey
wrote:

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?

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.

lmahaffey wrote:

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?

--

Dave Peterson