Formatting Cells to extend beyond 255 character limit

[Soozie]

How can someone change the format of a cell so that it will hold more than 255 characters?

 

[Guest]

Let me know when you get the answer. I need to know that as well please. If you could email me the answer at keverton@ecs-inc.com I would greatly appreciate it.

 

[Derek]

Hi Soozie
I don't think you can do this on a permanent basis but it would appear you can work with more than 255 characters in a cell. Sometimes when I go to copy a sheet a message tells me that some cells contain more than 255 characters which will be lost unless you actually copy those cells and paste to the new sheet. They will probably be truncated to 255 characters when you go to save.
regards
Derek

 

[Mark W.]

On 2002-03-08 06:22, Soozie wrote:
How can someone change the format of a cell so that it will hold more than 255 characters?

Formatting doesn't alter the contents of a worksheet cell. Furthermore, a cell can contain 32,000 characters.
This message was edited by Mark W. on 2002-03-08 07:44

 

[Barry Katcher]

[No message]

 

[Barry Katcher]

Good question. I think what Suzie meant is that when you wrap text in a cell, it will only show up to 255 characters. You can enter more characters than that but it shows as "XXXXXXXXXXXX".

If anyone has a work-around to this, I would also greatly appreciate knowing what it is.