Re: alignment with decimals & % sign

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Perhaps your "numbers" are numbers stored as text and right aligned. If
so, formatting as 0_% will have no effect.
You'll have to clean up your data to have numbers stored as numbers.

Tyro

"Janetoes" <Janetoes@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1CFF8EC9-FC0A-48A0-BF1E-7767BE814C3A@xxxxxxxxxxxxxxxx
I tried your suggestion. I have the column of numbers right aligned. I
selected from the 2nd row down, right mouse clicked, numbers tab , custom
and
pasted in 0_%. The numbers are still right aligned with no space to the
right. I sometimes also have numbers with the arrow symbol or ** at the
end.
Any suggestions for making them align?
Janetoes

"Tyro" wrote:

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" <Janetoes@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7B0B3B1D-5F04-4564-ADA5-C2C14DA93930@xxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: alignment with decimals & % sign
    ... I am new to Excel. ... You'll have to clean up your data to have numbers stored as numbers. ... Any suggestions for making them align? ... lines) in the column with a custom format such as 0_% assuming your ...
    (microsoft.public.excel.misc)
  • Re: Auto-formatting Time with a Query Table
    ... If so, you can custom format those cells to display mm:ss and suppress the "00:" part; if not, show us how Excel is displaying them. ...
    (microsoft.public.excel.programming)
  • Re: How to set the default date format to D/M/Y?
    ... Custom format date settings: ... International Preference, Date Format, Short Form: ... First observation, in previous versions of Excel the ... To obtain a date I have to type 4/13, disagreeing with the Preferences ...
    (microsoft.public.mac.office.excel)
  • Re: alignment with decimals & % sign
    ... 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 ... I cannot align columns of numbers the way I want. ...
    (microsoft.public.excel.misc)
  • traslation
    ... align 16, db 0 ... /* numero nello stack del chiamante in num1:num0 numero ... /* convert the number in format above in the 0 terminated ...
    (alt.lang.asm)