Text not showing up as text

**capnhud** · 01-13-2012, 11:11 AM

I have a document in which the text html entered into a cell and it is displaying as #################### even though I set the cell to word wrap and have expanded the cell to show more than enough rooom. What am I doing wrong

**sweep** · 01-13-2012, 11:20 AM

Hi,

There's a 255 character limit on text in a cell. Use =LEFT(A1,255) to show the first 255 characters.

**capnhud** · 01-13-2012, 11:38 AM

Originally Posted by sweep

Hi,

There's a 255 character limit on text in a cell. Use =LEFT(A1,255) to show the first 255 characters.

Ok I will try that but those cells are no different that the other types of cells that I have in the workbook which exceed 255 characters and come out just fine. The files has been updated to show that a cell with much more information displays as it should.

So what would be the correct way to format the cell to display the text correctly?

**capnhud** · 01-13-2012, 11:56 AM

Just in case someone else run into this problem the solution is the set the cell format to general which will allow you to see everything. If it set to text then you will see ########### if it exceeds 255 characters.