Use a Custom Format, such as

General;\0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tony" wrote in message
...
I would like some advise to show a zero value in a cell when ever the sum
value of this cell is a negative value