comma style button

A

AndrewD

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify Toolbar Button Styles 1
style button 3
About comma style in MS Excel 1
Applying Indian comma style 1
Comma Style Question 3
missing styles 3
How to change default value of comma style 1
Saving a custom number format 2

Top