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
external usenet poster
 
Posts: 11
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
Displaying text. RaY Excel Worksheet Functions 4 August 19th 08 10:48 AM
Text not displaying completely Valeria Excel Discussion (Misc queries) 5 January 12th 07 04:54 PM
HELP: text keeps on displaying ############## Dhruba Bandopadhyay Excel Worksheet Functions 2 March 27th 06 01:10 PM
trouble displaying as text RB Smissaert Excel Programming 2 June 18th 04 03:01 PM
text box displaying time? scrabtree23 Excel Programming 2 September 8th 03 08:29 PM


All times are GMT +1. The time now is 07:21 PM.

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"