View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Dhruba Bandopadhyay
 
Posts: n/a
Default 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?