text being returned as #######

[ACICS_Admin]

Text is being returned as ######## in a cell; however, when you click on the
cell it will actually display the text in a readable format. Please advise.

 

[Babymech]

Most likely your column just isn't wide enough for the text in the format
you've chosen. Expanding the column widht should do the trick.

 

[Jarek Kujawa]

expand yr column/row

 

[Dave Peterson]

Format the cell as General.

String lengths between 256 and 1024 in cells formatted as Text cause this
problem.

 

[ACICS_Admin]

I expanded the row and also have the 'wrap text' alignment on. Some cells
with text are just fine, while others are returnning the ######. Can you
think of anything else?

Thanks!