Thread
:
How to make negative numbers look like 0
View Single Post
#
4
Trisha V via OfficeKB.com
Posts: n/a
ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH A
FORMULA.
Marvin P. Winterbottom wrote:
make another column with a formula:
=IF(A1<0,0,A1)
--
Message posted via
http://www.officekb.com
Reply With Quote