OR maybe the decimal is missing?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"CLR" wrote in message
...
I'm not sure..........if I take a blank general-formatted cell and type in
29.5 and then apply the custom "("#.#"%)"
format to it, the cell displays (29.5%) here in my XL2k............maybe
you're using a different version of Excel and it's acting differently?

Vaya con Dios,
Chuck, CABGx3


"Carter Devereaux" wrote in
message ...
Your answer worked perfectly. Thanks. One more question related to your
solution: if I use Custom for example on 29.5, it rounds it up to 30; how
can
I get 29.5?

"CLR" wrote:

For display purposes, if you type 29.5 in a cell, you can format it
Custom
with "("#.#"%)"

It will show as (29.5%) but the actual value will be 29.5

Vaya con Dios,
Chuck CABGx3



"Carter Devereaux" wrote in
message ...
I'm trying to produce a series of percentage numbers in parentheses,
like
this, (29.5%). But Excel forces a negative format value on it. How can
I
produce what I want?