Q1. #####. To see the whole number widen the cell by either it wide or
autofit by double clicking. Both these are done by the column letters on the
right hand edge of the cell.

Q2. Format the cell as a number to get rid of scientific.

Mike

"John" wrote:

I have a spreadsheet that mut have thin columns (small width). The problem is
that some numbers are large and do not fit in the cell, so they show as
######## or in scientific format as 4E+10. Is it possible to show the number
which is partly lying outside a cell?