Negative numbers displaying as zero.
Posted by Dan Nero on June 13, 2001 7:24 AM
hello,
I am working on a spreadsheet that some of the multiplied columns result in a negative number. I am wanting the negative results displayed as a zero and not a negative value.
Please help and thank you in advance.
Dan
Posted by Mark W. on June 13, 2001 7:31 AM
Format the cell using... 0;"0"
Posted by Ivan F Moala on June 13, 2001 7:50 AM
Dan
Try a Custom format
Goto Format / Cells / Number / customs
then under type put this in ;
General;"0"
All negative numbers will appear as 0
HTH
Ivan
