LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell text based on 4 condition test Bob Wall Excel Worksheet Functions 3 November 16th 05 07:34 PM
Text Wrapping JMB Excel Discussion (Misc queries) 0 July 29th 05 02:41 AM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 03:37 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Vlookup did cell auto formating but not displaying complete text.. Roda Excel Worksheet Functions 2 December 27th 04 02:27 PM


All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"