How can I manipulate the Custom Number Format list?

[MigrantFirmWorker]

Anyone know how to access & manipulate the custom format list, aka, Format/Cells/Number/Custom ? When I assign a new format to a cell, it shows up in the list, but I haven't figured out how to query or delete items in the list.

 

[Nikita6003]

Hiya,

Excel stores the number formats within the application itself, and as far as I know there are no objects in VBA to access the list
BUT: have a look on

http://www.j-walk.com/ss/excel/eee/eee007.txt

– Leo Hauser wrote some code using SendKeys that’ll read the list of Custom Number Formats. If you want to delete any format you’ll need the text string that defines the format

You can delete numberformats using the .DeleteNumberFormats method (takes the numberformat as argument and applies to the Workbook object) but there’s no way you can delete Excel's built-in custom number formats.

As for adding formats to the list: all you can do is to use VBA to apply the formats you want added to a cell in the workbook where you want to have the formats available.

HTH


Cheers
Nikki
Look, mommy, I'm flying!