On 22/12/2010 19:36, Johnny Rosenberg wrote:
Den 2010-12-22 20:13:58 skrev Paul Cohen <[email protected]>:
Is there any way to format data in a column so that the decimal points
are aligned?
I thought that something like ”0,#####” should work, but it didn't… so
now we are two who want to know…
Perhaps you are trying to achieve something I don't understand but, from
your question, I'd say simply format the cells with a fixed number of
decimal places - Format>Cells>>Numbers>Options>Decimal Places - set the
value to, say, 2 and all the decimal points will line up. You can do it
for a whole column by selecting the column, or for a range of cells by
selecting only those cells. With a value of 2 in the Decimal Places
setting a value of 1234 will be shown as 1234.00 and a value 3.4 will
show as 3.40 so that the decimal point appears in the right place.
You can also set the next option in that same pane - "Leading Zeros". If
you set that to zero then the value 0.1 will appear as .10 but the
decimal point will still line up with the others. If you set it to 2
then 0.12 will appear as 00.12 and, again, the decimal point will be in
the right place.
I'm sorry, but this seems so fundamental that I think I must have
misunderstood something.
--
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
