TonyJag wrote:
Have you tried widening the column. If the number is too big, it will show
up as #'s.
[quoted text clipped - 3 lines]
row. Funny thing is autosumming the same data down a column is OK.
Any ideas folks?!
Michael, yes, tried that but even if I expand the column to a screen wide it
just keeps looking at me!
HOLD THE FRONT PAGE! Have just sussed it. # is showing the cell IS too small
for the number. The person seems to have changed the orientation of the cells
to vertical. Therefore if you increase the height of the cell the answer
appears with the numbers one above the other!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200510/1