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.