Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default How do I get more than 255 characters to display in a merged cell

When I put more than 255 characters in a merged cell all get is a line of
####...
How can I dispaly all the characteres?
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default How do I get more than 255 characters to display in a merged cell

Try changing the numberformat from Text to General.

If you have lots and lots of text, you may have to add alt-enters every 80-100
characters to see all the text.

RQS9 wrote:

When I put more than 255 characters in a merged cell all get is a line of
####...
How can I dispaly all the characteres?


--

Dave Peterson
Reply
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
'Grow' a merged cell when display is full. olwenh Excel Discussion (Misc queries) 3 June 26th 07 10:23 AM
Number of characters in a cell (one row, merged columns) Dajana Excel Discussion (Misc queries) 1 September 19th 05 09:30 PM
Max number if characters in a merged cell Dajana Excel Discussion (Misc queries) 1 September 7th 05 02:30 AM
Max number if characters in a merged cell Mike Excel Discussion (Misc queries) 0 September 7th 05 01:18 AM
How can I display and print all the data in a wrapped merged cell. lflinders Excel Discussion (Misc queries) 1 January 6th 05 02:05 AM


All times are GMT +1. The time now is 02:10 AM.

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

About Us

"It's about Microsoft Excel"