"Decimal tab" in Excel?
 

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!

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

"Sam" wrote:

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!

Sam,

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

Henry

"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!

Sam

Format as "Accounting" under FormatCellsNumber.

The decimal points will line up.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 13:59:03 -0700, Sam wrote:

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!

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!