Comma Style

[Funk]

How do I modify the comma style to allows display no decimals. I can modify the style for that workbook but open a brand new spreadsheet and then Excel defaults back to 2 decimal places. I have tried to save the setting in the normal template but it does not take.

 

[PaddyD]

try this - tgo to Tools | Options. Select the edit tab. Is 'Fixed decimal' checked?? If so, un-check it.

Paddy

 

[Mark W.]

Why not use the Comma[0] style?

 

[Funk]

How do I apply the Comma[0] to all new workbooks?

 

[Mark W.]

Assign the format...

_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)

...to the Normal style, Save as Book.xlt into your XLStart folder.

 

[Funk]

Thank you that worked!