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