Aligning periods while keeping them as a percent

[kfface]

I have fought with this for an hour or two and would greatly appreciate any help. I have a document that I need the periods to be aligned, the need to be in percent format with two decimal places. Some of the numbers have negatives and others have not. All help I've found doesn't keep the numbers in percents or replace the negative number with being in parenthesis.
In my document I have the following:
-12.36%
-1.05%
0.55%
5.02%
15.32%
I need to keep the numbers in this format while having the decimals aligned.
Thank you ahead of time.

 

[Rick Rothstein]

Yes I ended up doing something along these lines....

so if anyone can think of a format solution I certainly could use it down the road.

Not sure if you tried my "add spaces at end to the Custom Format" or not. If not, a Custom Format for the column like this is what I had in mind...

0.00%"    "

There are 4 spaces between the quotes... add as many additional ones as needed to make the group look more or less centered (how many spaces will depends on your column width).

 

[shg]

Formatting as "_-?0.00%;-?0.00%" will maintain decimal alignment when centered.

 

[gaz_chops]

Playing around, this might do it, note there are 2 spaces before the 1st 00.00%

00.00% ;-00.00%

Edit : forget this, shg's seems to do the job.

 

[Rick Rothstein]

Formatting as "_-?0.00%;-?0.00%" will maintain decimal alignment when centered.

Interesting... the centering looks "off" a little bit... it almost looks like the number itself is centered and then the % sign is tacked on afterwards... keep the column width somewhat smallish to see what I mean... also, there seems to be a space between a minus sign and the number (which I guess is due to the ? symbol you used; although without it, the alignment is off a little).

 

[kfface]

Formatting as "_-?0.00%;-?0.00%" will maintain decimal alignment when centered.

This definitely does the trick.
When I have numbers like -14.53, and -2.35 the -2.35 have a space between the negative and the number like this - 2.35. Is there a way to fix that or am I just being too picky?
Thank you very much shg

 

[shg]

I'd go with Rick's suggestion. I don't believe in centering numbers.

You could do it with conditional formatting, but it's way too much effort for the value.