View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
landrybj landrybj is offline
external usenet poster
 
Posts: 1
Default 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