View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gatsby Gatsby is offline
external usenet poster
 
Posts: 42
Default Decimal Point Vertical Alignment in Excel 2003

I have a column where I am putting in numbers with two decimal places.
On the toolbar I have aligned the column to fill in the numbers at 'Centre'.
The problem is:
If I put in a figure of say, 755.26 in a cell and in the cell underneath, I
put in 30.23, the decimal points don't line up.
If I align the figures to the right, everything is ok, but I want the
figures to be in the centre of the column.

The column just looks 'untidy' with the decimal points not lining up
vertically as I progress down the column.

Any ideas would be most appreciated,
Thanks,
Gatsby