"Decimal tab" in Excel?

[Guest]

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!

 

[Guest]

Format the cells as Number with as many decimal places as you need.

 

[Henry]

Sam,

If your numbers all have the same number of digits after the decimal point
(Currency) then right align your column.

Henry

 

[Gord Dibben]

Sam

Format as "Accounting" under Format>Cells>Number.

The decimal points will line up.


Gord Dibben Excel MVP

 

[Earl Kiosterud]

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).