I have spreadsheet which for some reason have a large number of custom number formats (pages and pages in the custom format pane). Some of them are so complex I can't even guess what they look like. I think this might be the cause of some bloating of file size (I've already deleted hundreds of custom styles and unused range names).
Is there some simple VBA I can use to delete all custom number formats that aren't built in to Excel? I used "stylekiller" to delete the custom styles and thought I could edit that VBA to delete custom number formats - but I can't see a way to do it.
Does anyone know a way?
Is there some simple VBA I can use to delete all custom number formats that aren't built in to Excel? I used "stylekiller" to delete the custom styles and thought I could edit that VBA to delete custom number formats - but I can't see a way to do it.
Does anyone know a way?