number formatting

[Guest]

i want all the decimal points to be in line for entire rows....for example
2333.21
233.21
23.21
2.21
please help me put all columns in one straight line

 

[Roger Govier]

Hi

Click on column heading, Format>Cells>Alignment>Horizontal>Right

 

[Sandy Mann]

I read it differently:

Try formatting the Column: Format > Cells > Number and selecting the
number of decimal places you want.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Roger Govier]

Hi Sandy

Who knows???

Columns and rows seem to have been used

please help me put all columns in one straight line

If the OP does both, then hopefully that will resolve the problem

 

[undrline via OfficeKB.com]

To my knowledge, you can't align cells to each other natively.
What I would do, is separate the number into two columns.

If your number is in cell A1:
The number before the decimal would be
=LEFT(A1,(SEARCH(".",A1))-1)
The number after the decimal would be
=RIGHT(A1,LEN(A1)-SEARCH(".",A1))

To translate:
starting from the left, take this number of characters: the number of
characters until the decimal, excluding the decimal itself

starting from the right, take this number of characters: the amount of
characters in the entire number, except the numbers up to and including the
decimal

Align one column to the left, and one to the right. If you want to keep the
decimal, I would create a centered column width of 1 between the two, that
just has a period in it - but you could also tack it on to either:
=LEFT(A1,(SEARCH(".",A1))-1)&"."
or
="."&RIGHT(A1,LEN(A1)-SEARCH(".",A1))
but you would lose the ability to manipulate the numbers this way, because it
would turn them into a string.

Hi Sandy

Who knows???

Columns and rows seem to have been used

please help me put all columns in one straight line

If the OP does both, then hopefully that will resolve the problem

I read it differently:

[quoted text clipped - 13 lines]