As a general rule I do not want zero's to visibly show in the sheet, but in
one specific column where the (pecentage variance) results of a calculation
show I need to see these results; positive, negative and zero if applicable.
How can I set up that these specific cells will visibily show a zero?

Select the sheet and format as

General;-General;

then select the cells that you want to show zero and use

General

if you use percentage you the same, semicolon tells excel

positive;negative;zero

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Swingbridge." wrote in message
...
As a general rule I do not want zero's to visibly show in the sheet, but
in
one specific column where the (pecentage variance) results of a
calculation
show I need to see these results; positive, negative and zero if
applicable.
How can I set up that these specific cells will visibily show a zero?

Custom format the entire sheet to hide zero's using
something like:

0;-0;;@

The key is that there is nothing after the 2nd semicolon.
Then select your specific column and custom format it as:

0.00%;-0.00%;0%;@

HTH
Jason
Atlanta, GA

-----Original Message-----
As a general rule I do not want zero's to visibly show
in the sheet, but in
one specific column where the (pecentage variance)
results of a calculation
show I need to see these results; positive, negative and
zero if applicable.
How can I set up that these specific cells will visibily
show a zero?
.