custom # format script


Posted by John S. on March 12, 2001 6:55 AM

I need the format for turning 0.00% into -% or just -

Posted by Roger Redhat on March 12, 2001 12:37 PM

0.00%;-0.00%;-\%



Posted by Mark W. on March 12, 2001 2:15 PM

John, you ought to bookmark the Excel Help Topic for
"Custom number, date, and time format codes". This
is one that you'll probably consult frequently.