I think your user has two things happening--not just wraptext and long text.

First, change the format to General. Excel has trouble displaying text between
255 and 1024 characters in a cell formatted as Text.

Second, if the text is long, then she may not see all the text in the cell.

But if she adds alt-enters (to force a new line within the cell), every 80-100
characters, she'll be able to see lots more.



Lori wrote:

A user created a sheet from scratch, originally the cell was formatted as
'General' and when she formatted the cell to wrap text, instead of changing
the row height and wrapping the cell displayed on only pound (or number)
signs for it's length.

I've selected the row and set to AutoFit. The cell is set to wrap,
reformatted for text, it contains a mix of text and numbers, and begins with
text.

I've copied the contents of the cell to notepad and pasted back in, same
issue. I can remove portions and paste them back in a piece at time and it
works fine, up to 255 characters. Resizing the column doesn't affect things.

If I format the column for text any cell containing more the 255 becomes all
pounds. Why won't it AutoFit for height when formatted for Text?

~Lori

--

Dave Peterson