LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Does the Text format have a size limit?

If the length of the string is between 256 and 1024 (inclusive), then you'll see
this problem. 255 or shorter or 1025 or longer and you'll be fine.



Glen wrote:

I formatted a cell in Excel as Text and had a paragraph in the cell. It
displayed as ##################### no mater what I did. When I changed the
format for the cell to 'general', it displayed the words correctly. Does
Text now have a size limit or something?

Thanks


--

Dave Peterson
 
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
Excel 2007 - change size of text as a result of conditional format Emece Excel Discussion (Misc queries) 4 December 4th 08 05:12 PM
conditional format text size Terry Excel Worksheet Functions 2 June 27th 06 11:09 AM
Cell size? Or size limit for Text data type? CClem Excel Discussion (Misc queries) 0 April 21st 06 04:09 PM
How to sent for cell: font size=7,text format in VBA netx Excel Discussion (Misc queries) 1 August 8th 05 06:50 PM
Is there a limit to the size of a cell containing text in Excel 20 Karen Setting up and Configuration of Excel 2 June 7th 05 01:47 PM


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