Text entry query

[Brian Tozer]

I am entering 5 lines of text into a block of cells and have Merge Cells
selected in Format | Cells.
When the last line exceeds a particular point in the text all that shows
when I try and enter it is a single long line of #s.
That line is not the longest line.
Help anyone?

Brian Tozer

 

[Dave Peterson]

Try formatting the cell as General (not Text).

If you need more than 1000 characters to show up in the cell, add a few
alt-enters to force a new line--you didn't ask--but it's a common question with
cells containing a lot of text.