Parentheses for Negative Percent Results - RESOLVED

[RAN_MPA]

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 ]

[zzydhf]

highlight the cells, right-click, format.
choose custom and paste this in the dialog box for "type": #,##0.0%;(#,##0.0%)

[RAN_MPA]

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

Thanks for your help.

[strussnat]

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

[pbowes]

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