Text entry query

  • Thread starter Thread starter Brian Tozer
  • Start date Start date
B

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

new line within a cell 2
Splitting up multiple lines in one cell to one line per cell inmultiple cells 5
Word Removing unwanted "lines" within a MS Word 10 table 1
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Excel can't display the text in one cell right if it's big 1
Removing unwanted "lines" within a MS Word 10 table 2
Form - how to get text to wrap 2
Wrap text does not adjust row height in merged cells. 2

Back
Top