formatting -% to be in (), rather than -

Tiina · May 15th, 2002, 02:26 PM

Hey,
A regular percentage formatting in excel will give me: -35.50%, however, my auditors are requiring it to look like this: (35.50%)
I've been playing around with the custom formatting, but don't seem to be able to figure it out.
Please help!
Thanks:o)

Juan Pablo González · May 15th, 2002, 02:27 PM

Try with

0.00%;(0.00%)

stone · May 15th, 2002, 02:46 PM

Do I understand you right;
you always want the percentage to be positive and in a ().

If so, if your number(s) is in cell F20
then type this in Cell G20

=IF(F20>0;"("&F20&"%"&")";"("&-1*F20&"%"&")")

Stulli

please correct me if Im wrong.

Mark W. · May 15th, 2002, 05:45 PM

Use...

0.00%_);(0.00%)

May 15th, 2002, 02:27 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Try with 0.00%;(0.00%) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 02:26 PM	#1
Tiina New Member Join Date: May 2002 Posts: 5	Hey, A regular percentage formatting in excel will give me: -35.50%, however, my auditors are requiring it to look like this: (35.50%) I've been playing around with the custom formatting, but don't seem to be able to figure it out. Please help! Thanks:o)

May 15th, 2002, 02:46 PM	#3
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	Do I understand you right; you always want the percentage to be positive and in a (). If so, if your number(s) is in cell F20 then type this in Cell G20 =IF(F20>0;"("&F20&"%"&")";"("&-1*F20&"%"&")") Stulli please correct me if Im wrong.

May 15th, 2002, 05:45 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Use... 0.00%_);(0.00%)