number formatting

S

Sam

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
 
S

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

[email protected]
[email protected] with @tiscali.co.uk
 
R

Roger Govier

Hi Sandy

Who knows???

Columns and rows seem to have been used
please help me put all columns in one straight line
Click to expand...

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

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.


Roger said:
Hi Sandy

Who knows???

Columns and rows seem to have been used
please help me put all columns in one straight line
Click to expand...

If the OP does both, then hopefully that will resolve the problem
I read it differently:
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
 
Top