Use something like
#;(#);;@

The trick is to have nothing between the second and third ";"
# is for positive numbers
(#) is for negative numbers
@ is for text


"texansgal" wrote:

I am trying to format at worksheet and use formula's to reference a different
page. What format can I use so that when there is no information entered in
the referenced cell it doesn't show a 0?