James,

You could use a custom format of "General;" (without the quotes) but the
negative value will still be in the cell and so will be used in any future
calculations. You could also add to yojur formula as in:

=IF(your formula <0,0,your formula)

or IF(your formula<0,"",your formula)

but in the second version the empty string may cause you problems if you use
it in other formulas.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"James" wrote in message
...
Hi I am working on real simple spreadsheet in Excel I have a little
problem.
I do not want to show negative numbers. For my spread sheet a negative is
mute so it is not needed. Any way to hide them?

Thank you,
James