Formatting Cells to extend beyond 255 character limit

Soozie · Mar 8th, 2002, 07:22 AM

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

Mar 8th, 2002, 07:35 AM

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 · Mar 8th, 2002, 08:17 AM

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. · Mar 8th, 2002, 08:38 AM

Quote:

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 · Mar 8th, 2002, 10:58 AM

Barry Katcher · Mar 8th, 2002, 11:02 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 07:22 AM	#1
Soozie New Member Join Date: Feb 2002 Posts: 13	How can someone change the format of a cell so that it will hold more than 255 characters?

Mar 8th, 2002, 07:35 AM	#2
Guest Posts: n/a	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.

Mar 8th, 2002, 08:17 AM	#3
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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

Mar 8th, 2002, 10:58 AM	#5
Barry Katcher Board Regular Join Date: Feb 2002 Location: Dog Beach, Florida. Yeaahh! Posts: 4,038

Mar 8th, 2002, 11:02 AM	#6
Barry Katcher Board Regular Join Date: Feb 2002 Location: Dog Beach, Florida. Yeaahh! Posts: 4,038	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.