Cell Text Length

G

Guest

Online help says that a cell will display 1,024 characters...anything longer
will display the ##### error. I am only able to enter 250 characters before
getting this display error.

Any suggestions?
 
G

Gord Dibben

Elisart

There seems to be a problem with text length between 256-1024 (0-255 and 1025+
work ok).

The bad news is that this is the way Excel works.

Re-formatting the cell(s) to General usually fixes the problem of the
#######'s

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text exceeds allowed number of characters per cell 1
limit on cell contents 1
Increasing # of Characters to display from a cell 6
Spell check / character cell limit 2
Cells only display a maximum number of text characters 4
Maximum characters in cell 2
Set the Length of the Cell 1
Re: Text limits in cell? 0

Top