Change default currency format in Excel 97.

[JackFly]

Using Excel 97, I want the ","(comma style) icon to reflect accounting format with no decimal places. Should this be modified in the personal.xls worksheet, or where?

 

[FASchw]

You can do this by right clicking on the cell or group of cells and choose formatting cell.  If the format you want is not listed choose custom and create what you want.

 

[JackFly]

I guess I wasn't specific enough.  When a new worksheet is created, the default accounting format is accounting with no dollar sign and 2 decimal places.  What I want is to be able to begin a new worksheet, click the Comma Icon on the formatting toolbar and have it reflect the accounting number format with 0 decimal places.  I want this to apply to all new workbooks, not just the current open book.  Thanks

 

[Guest_imported]

Try changing the style under Format>Style and choose the currency style.  

 

[Kuria]

Have you tried making the changes you desire then save thge file as book.xlt in the program Files\Microsoft office\office\Xlstart folder? You need to have renamed and moved the existent book.xlt. This will save all your formatting into this template which excel uses by default when you start it.