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?
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?
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" <[email protected]> wrote in
message news:[email protected]...
> 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?
>
>
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" <[email protected]> wrote in
> message news:[email protected]...
> > 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?
> >
> >
>
>
>
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" <[email protected]> wrote in
message news:[email protected]...
> 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" <[email protected]> wrote in
> > message news:[email protected]...
> > > 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?
> > >
> > >
> >
> >
> >
OR maybe the decimal is missing?
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------
"CLR" <[email protected]> wrote in message
news:%[email protected]...
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" <[email protected]> wrote in
message news:[email protected]...
> 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" <[email protected]> wrote in
> > message news:[email protected]...
> > > 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?
> > >
> > >
> >
> >
> >
It can be displayed by customising 29.5% in parantheses, as (#.#%). For this
right click any cell; press 'f' and in the Number tab click custom and type
the above format. Now you can type any number with percentage and format it
by clicking custom and select (#.#%) And now replicate the cell wherever you
want.
"Carter Devereaux" wrote:
> 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?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks