Lining up cells with % symbol to those without.
 

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

Lining up cells with % symbol to those without.
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"landrybj" wrote in message
...
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

Lining up cells with % symbol to those without.
 

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.


--
Regards,
Fred


"landrybj" wrote in message
...
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

Lining up cells with % symbol to those without.
 

One learns something everyday!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Fred Smith" wrote in message
...
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.


--
Regards,
Fred


"landrybj" wrote in message
...
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