Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comma style button
how to change the contents of the comma style button in formatting toolbar in
Excel 2003? I use a particular custom number format that derives from the comma style, but I would like to modify the comma style button to format numbers exactly as I want. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comma style button
You can change the Comma style:
Format|Style (in xl2003 menus) or Home tab|Style group|Cell Styles icon (on the xl2007 ribbon) Change the comma style to what you want. These styles live in workbooks. It's not an excel setting. So every existing file needs to have it changed (if you want). If you want this style for new workbooks, you can create a new workbook, save it as book.xlt (a template file) in the XLStart folder. A new workbook will be created based on this workbook when you click on the New Icon on the standard toolbar. AndrewD wrote: how to change the contents of the comma style button in formatting toolbar in Excel 2003? I use a particular custom number format that derives from the comma style, but I would like to modify the comma style button to format numbers exactly as I want. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comma Style Question | New Users to Excel | |||
How to change default value of comma style | Excel Discussion (Misc queries) | |||
About comma style in MS Excel | Excel Discussion (Misc queries) | |||
comma in indian style | Excel Discussion (Misc queries) | |||
Applying Indian comma style | Excel Discussion (Misc queries) |