I can hide zeroes but I also need to hide negative values as well. How can I
get negatives values to hide?
I can hide zeroes but I also need to hide negative values as well. How can I
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
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" <[email protected]> wrote in message
news:[email protected]...
>I can hide zeroes but I also need to hide negative values as well. How can
>I
> get negatives values to hide?
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" <[email protected]> wrote in message
> news:[email protected]...
> >I can hide zeroes but I also need to hide negative values as well. How can
> >I
> > get negatives values to hide?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks