ACTUALLY THIS IS NOT THAT EASY TO DO WHEN YOU'RE WORKING WITH A PIVOT TABLE
Gordon wrote:
"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)
No. There isn't. You can't "format" a cell to show a non-negative number.
What's the problem with putting the formula in a column next to the
original, and then hiding the original column?
--
Message posted via
http://www.officekb.com