Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home



Custom Number Format

Posted by Roger on July 11, 2001 3:52 AM
Sent this already but for some reason when I click onto the message board item I get the text of someone elses query.

My problem is that I want to change the number format of a cell to +0.0%;[red]-0.0%.

While I've done this many times in the past I am now getting a message 'no new formats can be added'

I am also unable to paintbrush copy and paste the format from another document - all that happens is that the cell goes to 0.00000 format.

Presumably there is a custom format file somewhere that is 'full' but I can't find any way to locate it and
It also puzzles me that ever time I create a new worksheet previous custom changes made on other documents don't get copied over into the custom format list.

Any suggestions? I am using Excel97.

I am using Excel97


Re: Custom Number Format

Posted by Mark W. on July 11, 2001 6:27 AM
Use the Format | Cells... menu command to open
the Format Cells dialog. Click on the "Custom"
category. Scroll to the bottom of the Type list,
and starting from the bottom of the list delete
all formats that you don't need up to the last
financial format that looks like...

_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

If the [ Delete ] button is greyed (ghosted) then
you know that the selected format is built-in, and \
cannot be deleted.




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.