adding parenthesis to values

J

John

Does anyone know how to display a percent within
parenthesis without turning it to text.

for example, instead of 12%
I want it to display (12%)

Thank you so much
 
T

Tina

You should be able to create a custom number format: In the Format Cells dialog box, under the number tab, click on custom. In the box, type: (0.00%) (or however many decimal places you'd like). Excel still sees it as a number (ie .25) and peforms calculations accordingly.
 
B

Bob Phillips

John,

Just use a custom format of (%0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Good grief, time to go to bed.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top