ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom Number Format List (https://www.excelbanter.com/excel-discussion-misc-queries/205612-custom-number-format-list.html)

JKinAK

Custom Number Format List
 
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

Sheeloo[_2_]

Custom Number Format List
 
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


JKinAK

Custom Number Format List
 
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



All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com