Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Excel to accept negative values using time-format | Excel Discussion (Misc queries) | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
How do i enter negative times in Excel & how can they be 'fiddled. | Excel Discussion (Misc queries) | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Excel - hide erroer values | Excel Discussion (Misc queries) |