Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum text length?
I have a spreadsheet with a cell formatted as text with word wrap turned on.
It appears to have some sort of limit as ### are being displayed even if cell is made larger in size?? Is there some kind of text length maximum in Excel?? Or can you change this some how? Your help would be greatly appreciated, Thx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum text length?
Don't format the cell as Text. Format it as General and I believe it will
remove the ### and wrap as you wish. I think you get this behavior when it is formatted as text and the length exceeds 255 characters. -- Regards, Tom Ogilvy "L Buchy" wrote in message ... I have a spreadsheet with a cell formatted as text with word wrap turned on. It appears to have some sort of limit as ### are being displayed even if cell is made larger in size?? Is there some kind of text length maximum in Excel?? Or can you change this some how? Your help would be greatly appreciated, Thx. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum text length?
Tom,
Working with Excel97 I just put 6,000 characters into a cell and didn't get the ### (formatted as General or Text). Of course not everything was displayed. Did find that when formatted as Text the ### showed up when the length was 256 to 1024 characters. Any less or any more and it displayed correctly. Now that is what I call strange!!! -- sb "Tom Ogilvy" wrote in message ... Don't format the cell as Text. Format it as General and I believe it will remove the ### and wrap as you wish. I think you get this behavior when it is formatted as text and the length exceeds 255 characters. -- Regards, Tom Ogilvy "L Buchy" wrote in message ... I have a spreadsheet with a cell formatted as text with word wrap turned on. It appears to have some sort of limit as ### are being displayed even if cell is made larger in size?? Is there some kind of text length maximum in Excel?? Or can you change this some how? Your help would be greatly appreciated, Thx. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum text length?
Good information. Did not examine the behavior that closely.
Regards, Tom Ogilvy "steve" wrote in message ... Tom, Working with Excel97 I just put 6,000 characters into a cell and didn't get the ### (formatted as General or Text). Of course not everything was displayed. Did find that when formatted as Text the ### showed up when the length was 256 to 1024 characters. Any less or any more and it displayed correctly. Now that is what I call strange!!! -- sb "Tom Ogilvy" wrote in message ... Don't format the cell as Text. Format it as General and I believe it will remove the ### and wrap as you wish. I think you get this behavior when it is formatted as text and the length exceeds 255 characters. -- Regards, Tom Ogilvy "L Buchy" wrote in message ... I have a spreadsheet with a cell formatted as text with word wrap turned on. It appears to have some sort of limit as ### are being displayed even if cell is made larger in size?? Is there some kind of text length maximum in Excel?? Or can you change this some how? Your help would be greatly appreciated, Thx. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum text length?
Tom,
Thanks! But!!! Any idea of what is going on here? Why the ###'s in the first place? And what's magic about 256 to 1024? Curious minds are still curious... -- sb "Tom Ogilvy" wrote in message ... Good information. Did not examine the behavior that closely. Regards, Tom Ogilvy "steve" wrote in message ... Tom, Working with Excel97 I just put 6,000 characters into a cell and didn't get the ### (formatted as General or Text). Of course not everything was displayed. Did find that when formatted as Text the ### showed up when the length was 256 to 1024 characters. Any less or any more and it displayed correctly. Now that is what I call strange!!! -- sb "Tom Ogilvy" wrote in message ... Don't format the cell as Text. Format it as General and I believe it will remove the ### and wrap as you wish. I think you get this behavior when it is formatted as text and the length exceeds 255 characters. -- Regards, Tom Ogilvy "L Buchy" wrote in message ... I have a spreadsheet with a cell formatted as text with word wrap turned on. It appears to have some sort of limit as ### are being displayed even if cell is made larger in size?? Is there some kind of text length maximum in Excel?? Or can you change this some how? Your help would be greatly appreciated, Thx. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum text length?
I would imagine it is residual from prevous versions. Text strings used to
be restricted to 255 characters - formulas could be up to 1024 (current limit). I suspect it has something to do with that. -- Regards, Tom Ogilvy steve wrote in message ... Tom, Thanks! But!!! Any idea of what is going on here? Why the ###'s in the first place? And what's magic about 256 to 1024? Curious minds are still curious... -- sb "Tom Ogilvy" wrote in message ... Good information. Did not examine the behavior that closely. Regards, Tom Ogilvy "steve" wrote in message ... Tom, Working with Excel97 I just put 6,000 characters into a cell and didn't get the ### (formatted as General or Text). Of course not everything was displayed. Did find that when formatted as Text the ### showed up when the length was 256 to 1024 characters. Any less or any more and it displayed correctly. Now that is what I call strange!!! -- sb "Tom Ogilvy" wrote in message ... Don't format the cell as Text. Format it as General and I believe it will remove the ### and wrap as you wish. I think you get this behavior when it is formatted as text and the length exceeds 255 characters. -- Regards, Tom Ogilvy "L Buchy" wrote in message ... I have a spreadsheet with a cell formatted as text with word wrap turned on. It appears to have some sort of limit as ### are being displayed even if cell is made larger in size?? Is there some kind of text length maximum in Excel?? Or can you change this some how? Your help would be greatly appreciated, Thx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum length of file name? | Excel Discussion (Misc queries) | |||
Maximum length of a number | Excel Worksheet Functions | |||
what is maximum row length in excel | Excel Discussion (Misc queries) | |||
maximum formula length | Excel Worksheet Functions | |||
Determine maximum length of a page | Excel Programming |