Try formatting the cell as General.

When you use a number format of Text, excel will have trouble with strings
between 255 and 1024 characters.





wrote:

I have a cell with about 500 characters of text that displays as a
single line of
number signs. There are no 'alt-enter' line breaks. This is not a
merged cell.

Under format cells, Alignment I have Wrap text selected. Under the
Number tab, I
have Text as the Category, and the sample shows the line of number
signs. If I
choose 'Special' and 'Zip Code' both the Sample box and the cell wrap
just fine
and display the all the text.

When displayed correctly, the cell is 83.71 wide and there a 6 lines of
text.

Thanks.

--

Dave Peterson