Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How do I add a custom format to the format drop down menu in Excel 2007? On the Home tab there is a "Number" section that has a format drop down box. Is there a way to customize the formats in that list?

I want to quickly format the cells with commas and zero decimal places. I can't seem to find a way to add that format to the drop down or to the quick access toolbar so it can be set with one click.

The "comma" button on the toolbar sets the accounting format which shows two decimal places. Otherwise that would work for my needs.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

First, create a macro that does what you want (see directions here). Click on the down arrow in the Quick Access Toolbar (upper-left) and choose, More Commands. Then in the first drop-down, choose Macros. Then add your macro, and say ok. Now when you click on that macro in the QAT, it will format your cell (you don't even have to have the Home Tab chosen).

When making the macro, I found that hitting the comma and then the 'less decimal places' button twice was the quickest way.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.