View Single Post
  #1   Report Post  
 
Posts: n/a
Default text display as #### instead of wrapping

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.