Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel Cell text limits
I've seen a couple of messages related to this, but the issue I have
seems to conflict with what is supposed to be the technical limits of Microsoft Excel I am using Microsoft Excel and have a column of single cells with text data. In most rows, this cell has less than 255 characters, however, in a few cells I have a lot more characters. Most of the cells with more than 255 actually have between 256 and 1024 characters. All these cells seem to only show hashes in the worksheet view, although the full text entry is present in the formula bar above the worksheet. However, I also have a couple of cells which have over 1025 characters, which display perfectly fine. So to sum up, cells with 0 - 255 characters display perfectly fine in the worksheet view. Cells with 256 - 1024 characters display 255 hashes. Cells with 1025 and more characters (so far I've tested with over 2000) display perfectly fine. I've read the display limit is 255, so if that's the case why does over 1024 display normally as well? Can anyone give me the definitive specifications and if it contradicts the information I have above, why? Thanks Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel Cell text limits
Are the relevant cells formatted as Text or as General?
Are they formatted to allow Wrap text? -- David Biddulph "Chris.Coops" wrote in message ups.com... I've seen a couple of messages related to this, but the issue I have seems to conflict with what is supposed to be the technical limits of Microsoft Excel I am using Microsoft Excel and have a column of single cells with text data. In most rows, this cell has less than 255 characters, however, in a few cells I have a lot more characters. Most of the cells with more than 255 actually have between 256 and 1024 characters. All these cells seem to only show hashes in the worksheet view, although the full text entry is present in the formula bar above the worksheet. However, I also have a couple of cells which have over 1025 characters, which display perfectly fine. So to sum up, cells with 0 - 255 characters display perfectly fine in the worksheet view. Cells with 256 - 1024 characters display 255 hashes. Cells with 1025 and more characters (so far I've tested with over 2000) display perfectly fine. I've read the display limit is 255, so if that's the case why does over 1024 display normally as well? Can anyone give me the definitive specifications and if it contradicts the information I have above, why? Thanks Chris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel Cell text limits
On 13 Aug, 15:10, "David Biddulph" <groups [at] biddulph.org.uk
wrote: Are the relevant cells formatted as Text or as General? Are they formatted to allow Wrap text? -- David Biddulph "Chris.Coops" wrote in message ups.com... I've seen a couple of messages related to this, but the issue I have seems to conflict with what is supposed to be the technical limits of Microsoft Excel I am using Microsoft Excel and have a column of single cells with text data. In most rows, this cell has less than 255 characters, however, in a few cells I have a lot more characters. Most of the cells with more than 255 actually have between 256 and 1024 characters. All these cells seem to only show hashes in the worksheet view, although the full text entry is present in the formula bar above the worksheet. However, I also have a couple of cells which have over 1025 characters, which display perfectly fine. So to sum up, cells with 0 - 255 characters display perfectly fine in the worksheet view. Cells with 256 - 1024 characters display 255 hashes. Cells with 1025 and more characters (so far I've tested with over 2000) display perfectly fine. I've read the display limit is 255, so if that's the case why does over 1024 display normally as well? Can anyone give me the definitive specifications and if it contradicts the information I have above, why? Thanks Chris- Hide quoted text - - Show quoted text - Cells are formatted as text. It was set without Wrap Text, but setting that option doesn't seem to work. However, once the number of characters gets above 1024, the wrap text option seems to work again... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Microsoft Excel Cell text limits
Chris
Excel has a problem when the cells are formatted to Text and contain between 256 and 1024 characters. You will get the ### pound signs. Format to General and they will go away. Gord Dibben MS Excel MVP On Mon, 13 Aug 2007 07:18:58 -0700, "Chris.Coops" wrote: On 13 Aug, 15:10, "David Biddulph" <groups [at] biddulph.org.uk wrote: Are the relevant cells formatted as Text or as General? Are they formatted to allow Wrap text? -- David Biddulph "Chris.Coops" wrote in message ups.com... I've seen a couple of messages related to this, but the issue I have seems to conflict with what is supposed to be the technical limits of Microsoft Excel I am using Microsoft Excel and have a column of single cells with text data. In most rows, this cell has less than 255 characters, however, in a few cells I have a lot more characters. Most of the cells with more than 255 actually have between 256 and 1024 characters. All these cells seem to only show hashes in the worksheet view, although the full text entry is present in the formula bar above the worksheet. However, I also have a couple of cells which have over 1025 characters, which display perfectly fine. So to sum up, cells with 0 - 255 characters display perfectly fine in the worksheet view. Cells with 256 - 1024 characters display 255 hashes. Cells with 1025 and more characters (so far I've tested with over 2000) display perfectly fine. I've read the display limit is 255, so if that's the case why does over 1024 display normally as well? Can anyone give me the definitive specifications and if it contradicts the information I have above, why? Thanks Chris- Hide quoted text - - Show quoted text - Cells are formatted as text. It was set without Wrap Text, but setting that option doesn't seem to work. However, once the number of characters gets above 1024, the wrap text option seems to work again... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW I CAN BLINK TEXT IN MICROSOFT EXCEL | Excel Discussion (Misc queries) | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
allow all text to be seen in a cell in microsoft excel | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
dealing with cell text limits | Excel Discussion (Misc queries) |