Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .