Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP: text keeps on displaying ##############
1. What is the maximum characters an Excel cell can take?
I try to import a very large text string into an Excel cell. I notice that it's truncated to a certain maximum length. When I set the cell type to be TEXT it displays ######################### But when I set cell type to GENERAL then it displays ok. Is this a normal common problem? I just did a Len() on my text cell and it appears the maximum characters allowed is 330. Is it possible to extend this? |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP: text keeps on displaying ##############
#1. In xl97+, it's 32,767 characters per cell. Excel's help says you can see
1024 characters, but you can see more if you add alt-enters (to force new lines within the cell) every 80-100 characters. Change the format back to General--anything but Text and you'll see the text. Excel has trouble showing long text (between 255 and 1024 characters) when the cell is formatted as Text. Dhruba Bandopadhyay wrote: 1. What is the maximum characters an Excel cell can take? I try to import a very large text string into an Excel cell. I notice that it's truncated to a certain maximum length. When I set the cell type to be TEXT it displays ######################### But when I set cell type to GENERAL then it displays ok. Is this a normal common problem? I just did a Len() on my text cell and it appears the maximum characters allowed is 330. Is it possible to extend this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
HELP: text keeps on displaying ##############
I'm in Excel 2003 - the limit in a cell appears to be 32,767 characters and
I'm getting none of the Text v. General formatting problems you mention. I have come across this kind of restriction when importing from Access as it assumes the old Excel limit of 256 and (unnecessarily for Excel 2000 and 2003) truncates everything after that. "Dhruba Bandopadhyay" wrote: 1. What is the maximum characters an Excel cell can take? I try to import a very large text string into an Excel cell. I notice that it's truncated to a certain maximum length. When I set the cell type to be TEXT it displays ######################### But when I set cell type to GENERAL then it displays ok. Is this a normal common problem? I just did a Len() on my text cell and it appears the maximum characters allowed is 330. Is it possible to extend this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying text. | Excel Worksheet Functions | |||
Text not displaying completely | Excel Discussion (Misc queries) | |||
HELP: text keeps on displaying ############## | Excel Worksheet Functions | |||
trouble displaying as text | Excel Programming | |||
text box displaying time? | Excel Programming |