software

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

Select the range (or column)
A) Use Format|Conditional Formatting
Specify quot;Cell valuequot;, quot;Is less thanquot; quot;0quot; and make the font white (or colour
of cell background) that it disappears
or B) use Format | Custom Format using something like $#,##0.00;quot;quot;
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;ccarollaquot; gt; wrote in message
...
gt;I can hide zeroes but I also need to hide negative values as well. How can
gt;I
gt; get negatives values to hide?

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: www.excelforum.com/member.php...oamp;userid=19048
View this thread: www.excelforum.com/showthread...hreadid=493225that worked. thanks

quot;Bernard Liengmequot; wrote:

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