| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : How to set thousand separator at tool bar ?
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 -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : How to set thousand separator at tool bar ?
FormatStyleCommaModify.
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 On Wed, 9 Apr 2008 07:19:01 -0700, Mr. Low wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : How to set thousand separator at tool bar ?
Hello Gord,
Thanks for the tip. Low -- A36B58K641 "Gord Dibben" wrote: FormatStyleCommaModify. 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 On Wed, 9 Apr 2008 07:19:01 -0700, Mr. Low wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| thousand separator | Excel Discussion (Misc queries) | |||
| Ctrl+Shift+! for two decmial places with thousand separator | Excel Discussion (Misc queries) | |||
| thousand separator conversion from dot to comma | Excel Discussion (Misc queries) | |||
| thousand separator | Setting up and Configuration of Excel | |||
| thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
Hybrid Mode
