Excel 2002 : How to set thousand separator at tool bar ?

[Mr. Low]

Dear Sir,

The numeric format ( Comma Sign ) at my tool bar is a number with two
decimal places without a thousand separator.

May I know how change the default of this icon to two decimal places with a
thousand separator (e.g. 12,145.26) ?

Also when I go to Format Cells > Numbers , the thousand separator box always
uncheck, can I change this default to always check ?


Thanks

Low

 

[Gord Dibben]

Format>Style>Comma>Modify.

To have thousand separator checked by default you would have to create a
template for the default workbook or have your Personal.xls make the setting via
Workbook_Open code.


Gord Dibben MS Excel MVP

 

[Mr. Low]

Hello Gord,

Thanks for the tip.

Low