Tags: comma, default, excel, format, icon, microsoft, modify, msdn, numbers, software, style, toolbar

Comma Style format, default change

On Microsoft » Microsoft Excel

1,211 words with 1 Comments; publish: Thu, 22 May 2008 23:41:00 GMT; (30646.88, « »)

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

All Comments

Leave a comment...

  • 1 Comments
    • 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.

      Dave wrote:

      > 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

      --

      Dave Peterson

      ec35720.excel.questionfor.info.msn.com

      #1; Thu, 22 May 2008 23:42:00 GMT