I understand now, Bernard, thanks.
I noticed that if I changed the the figure on the underneath cell, in the
example, from 30.23 to 130.23, the decimael point aligns with the one above.

Maybe Microsoft will introduce a 'wider decimal point character', in the
future, that would do away with this problem.
Surely I'm not the only Microsoft user that has had this problem?

Gatsby.





"Bernard Liengme" wrote:

The numbers are centered based on how much space they take up - in text like
form. The decimal is taken to be just a character with a small width.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gatsby" wrote in message
...


"Bernard Liengme" wrote:

It either centred or right aligned. No combination is possible. You could
add a small, blank column to the left to make print out 'prettier'
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gatsby" wrote in message
...
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


Thanks for taking the trouble to reply, Bernard.
Why don't they line up, vertically, do you know?
Gatsby