If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2007 Character Display
Is there a limit on the number of characters that will properly display in an
Excel 2007 cell? When I enter text with more than 259 characters, the cell displays all #####. This happens no matter how I size the cell or whether I have text wrap turned off or on. Is there a way to change the size limit that will display? |
#2
|
|||
|
|||
Excel 2007 Character Display
Excel has always had a problem showing text when number of characters is
betweem 255 and 1024 when the cell has been formatted to TEXT Re-format to General and the ############## wil go away. Gord Dibben MS Excel MVP On Thu, 20 Aug 2009 14:14:01 -0700, rflinn wrote: Is there a limit on the number of characters that will properly display in an Excel 2007 cell? When I enter text with more than 259 characters, the cell displays all #####. This happens no matter how I size the cell or whether I have text wrap turned off or on. Is there a way to change the size limit that will display? |
#3
|
|||
|
|||
Excel 2007 Character Display
I concur with Gord Dibben's response. I did that just today. If you change
the cell to "General" format, all of the text will display. I also recommend changing the cell to "Wrap Text" to allow you to keep the cell at a limited width, but still able to see all the text. -- Thanks - Robin B! "rflinn" wrote: Is there a limit on the number of characters that will properly display in an Excel 2007 cell? When I enter text with more than 259 characters, the cell displays all #####. This happens no matter how I size the cell or whether I have text wrap turned off or on. Is there a way to change the size limit that will display? |
Thread Tools | |
Display Modes | |
|
|