Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why do I see " too many formats" message in Excel 2007 | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Excel: how to convert "27.11.2007 15:13" to number (cellformat fai | Excel Discussion (Misc queries) | |||
Does "Too many different cell formats" apply on excel 2007 | Excel Discussion (Misc queries) | |||
Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) |