View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Robin B! Robin B! is offline
external usenet poster
 
Posts: 2
Default In Excel 2007, can you add "custom" formats to number format dropd

In Excel 2007 on the "Home" tab there is a "Number" section, which provides a
dropdown list that gives you the following options:
. General
. Number
. Currency
. Accounting
. Short Date
. Long Date
. Time
. Percent
. Fraction
. Scientific
. Text
. More Number Formats ...

When you select "More Number Formats, you can build a "Custom" format. I
have to use the following format frequently "[$-409]mm/dd/yyyy h:mm AM/PM;@".

I was wondering if there is a way to add that custom format to the dropdown
list so that I don't have to manually rebuild it every time I need to use it.

Any assistance will be greatly appreciated.

--
Thanks - Robin B!