Sam,
To line up the decimal points, use Format - Cells - Number tab - Custom with
one of the following codes, depending on the number formatting you want:
0.???
..???
#,###.???
0.000
..000
#,###.000
The secret to lining up the decimals is the number of formatting characters
to the right of the decimal point. Use any count of those you want. Numbers
with more digits to the right will be rounded. For example, if you've used
0.??? and the number is 0.1237, you'll get 0.124. (Well, it's closer than
0.123).
--
Earl Kiosterud
www.smokeylake.com
"Sam" wrote in message
...
Hello
I have a column of numbers in Excel [the column is part of a table]. I am
pasting it into Word as a Picture (Enhanced Metafile). I would like to
align
the numbers in this column in such a way so that the decimal points line
up
one under the another. Thus far, I was not successful, as these numbers
have
different number of digits before the decimal point. Is there a way of
having the equivalent of a "decimal tab" in Excel?
Thank you!