Comma Style format, default change

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I'd like to change my comma for numbers:
1,000.00 to be 1,000
I can change the style in the toolbar icon (modify), but
that only works for the current file. when i open another
spreadsheet the toolbar icon puts to two zeros back into
the right of the decimal point.
HOW CAN I PERM. CHANGE THE COMMA STYLE ICON?
DAVE
 
You can change it for any new workbooks that are based on a template.

Create new workbook with that style. Then save it in your XLStart folder
(location varies with versions of windows & excel).

Now each workbook you create new will use that as the default.

You could also merge the style from one workbook (just an empty one will do) to
another and have the Style set the way you want.
 
Back
Top