ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Escel 2003 Comma Style on Toolbar will not work (https://www.excelbanter.com/excel-worksheet-functions/224919-escel-2003-comma-style-toolbar-will-not-work.html)

lmahaffey

Escel 2003 Comma Style on Toolbar will not work
 
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

Escel 2003 Comma Style on Toolbar will not 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?



Dave Peterson

Escel 2003 Comma Style on Toolbar will not 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


All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com