Lining up cells with % symbol to those without.

[Guest]

Hello,
I am trying to create a table that lists the weights of categories as a % of
the total. The problem is I need the table formatted so that the first
category reads xx.x%, while all the remaining categories read xx.x (still a
percent but not displaying the percent sign). I also need a total at the
bottom of the list to sum the percents (i can cheat and do this a different
way) that should read xx.x%.. See below for example.

25.3%
22.3
2.3
50.1
100.0%

The goal is to not have the % symbol on the middle lines and have the
decimals line up.

Thanks,

Brady

 

[Bernard Liengme]

Select the middle cells (those without %)
Use Format | Cells -> Custom and make the format General" "
I got good results with 5 spaces between the double quotes.
Also note the cell values still behave as numeric values.
Be careful though: the top value is 0.253 while the second one is 22.3
You will need to compensate for this in all formulas as in
=A1+SUM(A2:A4)/100 to get the correct sum
best wishes

 

[Fred Smith]

Use a custom format of 0.0_%

The underscore tells Excel to reserve space for the % sign even though it's not
displayed. This feature is most commonly used in accounting format where
negative numbers are shown in brackets, but you want positive numbers to line up
under the decimal point. However, it works equally well with a percent sign.

 

[Bernard Liengme]

One learns something everyday!