thanks

Bernie Deitrick wrote:
Trisha,

A custom format of

0;"0";0

will display negative numbers as zero, though it won't change the underlying value.

HTH,
Bernie
MS Excel MVP

"Trisha V via OfficeKB.com" wrote in message ...
ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A
FORMULA.

make another column with a formula:

=IF(A1<0,0,A1)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1