adding parenthesis to values

[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

 

[kkknie]

Use a custom format for the cells of (0%)

 

[Guest]

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.

 

[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)

 

[Frank Kabel]

Hi
apply a custom format ('Format - Cells'). e.g.
(0%)

 

[Frank Kabel]

Hi Bob
you probably meant
(0%)

 

[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)