Making negative numbers zero

[Roger R]

How do I format a column to make all negative number show
up as Zero (0)?

thx

 

[Frank Kabel]

Hi
you may apply the following custom format:
0.00;"0";0.00

 

[Guest]

Frank,
should this format be an option in my custom format list,
because I'm not finding it. I've tried to manipulate an
exsisting format that is close to what you have given me,
but it brings up a message that "no more customer number
formats can be added"

thx

 

[Frank Kabel]

Hi
you have to enter this format manually in the textbox above the list
with the existing custom formats

 

[Guest]

Ok, but that is when I get the message that no more can be
added.

 

[Roger R]

Frank,
I've gone back to this and finally made it work, I had to
format a blank sheet, then drop the numbers in, the
problem is that it didn't work. It made all of the whole
numbers into zero, and left the negative numbers as
negative. Is there a formula that I could use? One other
thing the negative numbers are imported in with the
negative sign after the number (4-), which might not make
a difference but I thought you should know.