Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way to organize the Custom Number Format List?
I use many custom # formats (30+) and I would like to be able to organize them in related groups such as time, materials, rate of production, and so on. Thanks in advance, -- John |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry, the answer is no.
You can develop a macro which gives you a dropdown list of formats to choose from or You can have a toolbar with one button each for respective formats or you can keep a spreadsheet with applied formats and use it to paint the cells you want... "JKinAK" wrote: Is there a way to organize the Custom Number Format List? I use many custom # formats (30+) and I would like to be able to organize them in related groups such as time, materials, rate of production, and so on. Thanks in advance, -- John |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks much Sheelo,
I'll look into building a dropdown list via macro - until that's complete, I'll put each format in a cell and paint away. -- John "Sheeloo" wrote: Sorry, the answer is no. You can develop a macro which gives you a dropdown list of formats to choose from or You can have a toolbar with one button each for respective formats or you can keep a spreadsheet with applied formats and use it to paint the cells you want... "JKinAK" wrote: Is there a way to organize the Custom Number Format List? I use many custom # formats (30+) and I would like to be able to organize them in related groups such as time, materials, rate of production, and so on. Thanks in advance, -- John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom number format for driver's license number | Excel Discussion (Misc queries) | |||
Moving custom number format to NUMBER | Setting up and Configuration of Excel | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) |