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