Custom cell format for percentage
 

I'm trying to figure out how to do a custom cell format for percentages.
Currently the negative percentage numbers show up as -100%. I'm trying to
figure out if there is a way to make them display as (-100%) instead (with
brackets but not in red).

Does anyone know if this is possible?

Thanks very much

Custom cell format for percentage
 

Format--Cells--Custom format
0.00%;(-0.00%)
This will put a parentheses around a negative percent as well as put the
negative sign.
--
John C


"Klee" wrote:

I'm trying to figure out how to do a custom cell format for percentages.
Currently the negative percentage numbers show up as -100%. I'm trying to
figure out if there is a way to make them display as (-100%) instead (with
brackets but not in red).

Does anyone know if this is possible?

Thanks very much

Custom cell format for percentage
 

Thanks so much, I thought I had tried that but it was making all of my
positive amounts negative so I must have done something wrong. It works great
now.

Thanks again!

"John C" wrote:

Format--Cells--Custom format
0.00%;(-0.00%)
This will put a parentheses around a negative percent as well as put the
negative sign.
--
John C


"Klee" wrote:

I'm trying to figure out how to do a custom cell format for percentages.
Currently the negative percentage numbers show up as -100%. I'm trying to
figure out if there is a way to make them display as (-100%) instead (with
brackets but not in red).

Does anyone know if this is possible?

Thanks very much

Custom cell format for percentage
 

Thanks for the feedback, and don't forget to check the box :)
--
John C


"Klee" wrote:

Thanks so much, I thought I had tried that but it was making all of my
positive amounts negative so I must have done something wrong. It works great
now.

Thanks again!

"John C" wrote:

Format--Cells--Custom format
0.00%;(-0.00%)
This will put a parentheses around a negative percent as well as put the
negative sign.
--
John C


"Klee" wrote:

I'm trying to figure out how to do a custom cell format for percentages.
Currently the negative percentage numbers show up as -100%. I'm trying to
figure out if there is a way to make them display as (-100%) instead (with
brackets but not in red).

Does anyone know if this is possible?

Thanks very much