how do i hide negative values in excel
 

I can hide zeroes but I also need to hide negative values as well. How can I
get negatives values to hide?

how do i hide negative values in excel
 

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?

how do i hide negative values in excel
 

I don't know if this is the answer your looking for. You could do some
conditional formatting where if the value is negative you change the
format of the text to white so you can't see the numbers. Format --
Conditional Formatting
Cell Value is less than 0


--
jayd77
------------------------------------------------------------------------
jayd77's Profile: http://www.excelforum.com/member.php...o&userid=19048
View this thread: http://www.excelforum.com/showthread...hreadid=493225

how do i hide negative values in excel
 

that worked. thanks

"Bernard Liengme" wrote:

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?