Is 255 characters in a cell the max?

  • Thread starter Thread starter Mike_S
  • Start date Start date
M

Mike_S

After 255 characters (text) in a cell in Excel 97, the cell only displays a
row of ####. If I double click the cell the text will appear but as soon as
I move to another cell the pound symbols are displayed. I can't print the
sheet with the text showing. Doesn't matter how I resize the cell.
The Excel book says 255 characters are the max allowed per cell. Can this
limitation be changed?
 
Mike,

I posted the same message the other day
under "Miscellaneous" and have just read the replies.
Although I haven't tried it yet, I was told to try to
change the cell format from text to general. Hope it
helps. Or you'll just have to be more parsimonious.

Janet
 
xl97 supports up to 32k characters in a cell.

Try changing that cell's format from Text to General.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How can I increase the number of characters allowed in a cell? 1
How do I get more than 255 characters to display in a merged cell 1
Word wrap with > 255 characters 2
Excel 2007 Character Display 2
How can I copy more than 255 characters in a cell without truncati 1
How do I get more than 255 characters into a cell? 3
Trouble with 255 characters max in a cell 3

Back
Top