You can format the rows beginning with row 2 (not lines, Excel does not have
lines) in the column with a custom format such as 0_% assuming your numbers
after row 1, the row with the percent, are whole numbers - no fractions.
0_% tells Excel to format the number as a whole number (0) and leave a space
at the right equal in size to the space occupied by a % sign (_%).

Tyro

"Janetoes" wrote in message
...
Excel spreadsheets are created in another department and I put them into
PPT.
I cannot align columns of numbers the way I want. The first line of the
column is usually 2 digits and then a percent sign. The rest of the
numbers
do not have the % sign. In Excel, I cannot find an align on decimal, and
if
you right align, it is off. I need the numbers centered in the column but
aligned by decimal. I really do not want to have to put blank spaces in
the
numbers. (Is there an easy way to do put in blank spaces? And the only way
I
can do that is to use the underscore and color it white.)
EX:
28%
133
5
23
Any help would be greatly appreciated.
THanks
Janetoes