show number larger than cell
 

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?

show number larger than cell
 

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?

show number larger than cell
 

Numbers have to fit in the cell. Text can overflow to the adjacent empty cells.

You could widen the column or change the font:
format|Cells|Alignment tab|check Shrink to fit


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?

--

Dave Peterson