View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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!