Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Format Negative Pecentage (Excel 2003)

    Does anyone know if you can get Excel to display a Negative Percentage as (3.5%) rather than -3.5%?
    As a workaround what I usually do is use number formats in one column and then add % in the Col next to it so you end up with (3.5)% in other words it gets split in two columns
    Is there a direct way to have Excel do this formatting.

    Regards,
    Tom Duthie

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Negative Pecentage (Excel 2003)

    Select the cell(s) you want to change and right click on one of the cell and choose Format Cell (or go to the format menu and choose Cells....) While on the Number tab, scroll to Custom in the left hand pane, in the Type box enter:

    0.00%;0.00%;

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Negative Pecentage (Excel 2003)

    Yes, with a custom format.
    - Select the cell or cells that you want to format.
    - Select Format | Cells...
    - Activate the Number tab.
    - Select Custom in the list of Categories.
    - Enter the following into the Type box:
    <code>
    0.0%_);(0.0%)
    </code>
    The first section (before the semicolon) is for positive numbers (and zero), the second section for negative numbers.
    The _) at the end of the first section adds a space the width of a closing parenthesis ) on the right, so that positive numbers align correctly with negative ones.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Negative Pecentage (Excel 2003)

    Your format would display -3.5% as 3.50%, and it would hide zero values.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Format Negative Pecentage (Excel 2003)

    Hans:

    Thank you. It worked.

    Regards,
    Tom Duthie

Posting Permissions

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