Select the range (or column)
A) Use Format|Conditional Formatting
Specify "Cell value", "Is less than" "0" and make the font white (or colour
of cell background) that it disappears
or B) use Format | Custom Format using something like $#,##0.00;""
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"ccarolla" wrote in message
...
I can hide zeroes but I also need to hide negative values as well. How can
I
get negatives values to hide?