Results 1 to 6 of 6
Like Tree1Likes
  • 1 Post By zzydhf

Parentheses for Negative Percent Results - RESOLVED

This is a discussion on Parentheses for Negative Percent Results - RESOLVED within the Excel Questions forums, part of the Question Forums category; I have been able to format single cells to display negative percents (Budget to Actual hours), but I cannot copy ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Location
    Ventura, CA
    Posts
    43

    Default

    I have been able to format single cells to display negative percents (Budget to Actual hours), but I cannot copy the formatting to cells with positive percents without eliminating the format style I want. [I need to display, with the parenthesis, (13.6%)for negative results, but say, 18.6% for positive results.] When I copy the correctly formatted cell (13.6%) to another cell with a positive result, it sets the display to general formating.

    As I have over 25 rows of data to compare against 62 projects and 12 programs, with each value potentially changing from one analysis to the other, I am looking for a method to automatically change the "look" of the results.

    I have looked at conditional formatting, but have had no indication this will do what I am looking for.

    Any ideas on how to perform this task?

    Thanks.

    _________________
    RAN_MPA

    [ This Message was edited by: RAN_MPA on 2002-07-15 14:48 ]

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    N.E. Ohio
    Posts
    236

    Default

    highlight the cells, right-click, format.
    choose custom and paste this in the dialog box for "type": #,##0.0%;(#,##0.0%)
    AnayaLiza likes this.
    Oh, you hate your job? Why didn't you say so? There's a support group
    for that. It's called EVERYBODY, and they meet at the bar. - Drew Carey

  3. #3
    New Member
    Join Date
    Jun 2002
    Location
    Ventura, CA
    Posts
    43

    Default

    I almost had it; I left off one important element.

    Thanks for your help.

  4. #4
    New Member
    Join Date
    Mar 2009
    Posts
    1

    Default Re: Parentheses for Negative Percent Results - RESOLVED

    zzydhf -- thanks so much for that formula.
    it totally saved me for this months reporting.

  5. #5
    New Member
    Join Date
    Oct 2010
    Posts
    2

    Default Re: Parentheses for Negative Percent Results - RESOLVED

    Very nice - I've been looking for how to do that. Thanks!

  6. #6
    New Member
    Join Date
    Jul 2014
    Posts
    1

    Default Re: Parentheses for Negative Percent Results - RESOLVED

    Thank you for your help! Perfect answer to that question.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com