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?