If you want to retain the underlying value, but just show the 0 value, use a
format like General;\0

--
HTH

Bob Phillips

"marcus1066" <marcus1066@discussions.microsoft.com> wrote in message
news:B519F61E-B641-4936-8746-7F535AE314DD@microsoft.com...
> I have a cell which has a basic formula in (adding up from 2 other cells)
> This number can end up being a minus number (-167), If this happens I need
to
> be able to make that minus number appear as a zero (0). Is this possible?
> please help.