Or double click the line to the right of the cell header to have Excel
automatically widen the column to the right size
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"Ray" <I ate wrote in message
...
It's because the cell is not wide enough to show the whole number.
Widen the column by clicking on the line to the right of the column
letter, then drag the column to the required width.
Alternatively highlight the whole column by right clicking on the letter
then select column width and increase the size.


"vpadid" wrote in message
...
I do the formula =SUM(E9:E24) and I get ##### in my cell. I put the
curser
on it and it shows the number in a balloon but not in the cell and it
messes
my final totals. Why does it happen, and how do I fix it?