LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Cell limit of characters

HelpSpecifications states

You can enter 32767 characters in a cell but only 1024 of those will be
visible or can be printed. The formula bar will show all characters.

How are you entering the data that limits you to 250 characters?

How did you determine that you are seeing only 250 characters?


Gord Dibben MS Excel MVP

On Thu, 23 Oct 2008 08:44:01 -0700, Kaylen
wrote:

Is there a way for Excel to allow a cell or a column of cells to have more
than 250 characters? I am creating a form that has a comment section.
Sometime when a comment is lengthy and exceed 250 characters, excel only
shows the first 250 characters and cut off the rest (both on screen and when
printed). Is there a way to allow a cell to show 250+ characters?

Any help is apprecited. Thank you.




 
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
How to limit the characters in a cell Igneshwara reddy[_2_] Excel Worksheet Functions 1 June 16th 08 03:32 PM
How to limit cell to 30 characters or less Gretta Excel Discussion (Misc queries) 2 March 21st 07 08:05 PM
How do I limit characters in a cell? casey Excel Worksheet Functions 5 October 4th 06 01:33 AM
Can I limit a cell to 2 characters? Frankc Excel Discussion (Misc queries) 2 August 11th 05 01:03 AM
Can I limit a cell to 72 characters? How? Chris Excel Discussion (Misc queries) 2 December 28th 04 04:57 PM


All times are GMT +1. The time now is 06:57 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"