Re: alignment with decimals & % sign

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

I have a column of numbers formatted general, I select the numbers, then
Ctrl+1, select numbers tab, custom, and under Type: I enter 0_% (0 (zero),
underscore, %) and click ok. All of the numbers shift left in their cells to
leave enough space for a rightmost % sign.

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: 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)
  • Re: alignment with decimals & % sign
    ... lines) in the column with a custom format such as 0_% assuming your ... I cannot align columns of numbers the way I want. ... In Excel, I cannot find an align on decimal, ...
    (microsoft.public.excel.misc)
  • Re: Formula problem with leading zeros
    ... > i am trying to cmbine them but excel drops the zeros in the formula. ... Note that the underscore is a special character in a format, ...
    (microsoft.public.mac.office.excel)
  • Re: Hard return in wraptext cell?
    ... place the cursor at the end of the line before the new line and press Delete ... text format ... so as to align text in the way user wants rather than what excel places? ...
    (microsoft.public.excel)