+ Reply to Thread
Results 1 to 4 of 4

how do i hide negative values in excel

  1. #1
    ccarolla
    Guest

    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. #2
    Registered User
    Join Date
    01-26-2005
    Posts
    11
    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

  3. #3
    Bernard Liengme
    Guest

    Re: 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" <ccarolla@discussions.microsoft.com> wrote in message
    news:B93420D3-05BD-4A84-8EC0-C12612D23C2E@microsoft.com...
    >I can hide zeroes but I also need to hide negative values as well. How can
    >I
    > get negatives values to hide?




  4. #4
    ccarolla
    Guest

    Re: 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" <ccarolla@discussions.microsoft.com> wrote in message
    > news:B93420D3-05BD-4A84-8EC0-C12612D23C2E@microsoft.com...
    > >I can hide zeroes but I also need to hide negative values as well. How can
    > >I
    > > get negatives values to hide?

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1