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 |
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) |