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?
|