PDA

View Full Version : Maximum number of characters in cell



CptGreenwood
10-11-2005, 07:35 AM
Is there a limitation of the number of characters an excel-cell can hold?
I have a large cell formatted with "text" and "word wrap" and want to use it for input of longer texts.
When I write more than 255 characters the cell shows "#########".
Is there a way to change that?

Zack Barresse
10-11-2005, 09:14 AM
Hello and welcome to VBAX!!

Check out this blog about Office 12 to see the current and upcoming restrictions: http://blogs.msdn.com/excel/

To combat any autofit nuances, check out this KB entry.

malik641
10-11-2005, 08:46 PM
Is there a limitation of the number of characters an excel-cell can hold?
I have a large cell formatted with "text" and "word wrap" and want to use it for input of longer texts.
When I write more than 255 characters the cell shows "#########".
Is there a way to change that?What version of excel are you using? I know that (at least) Excel 97 through Excel 2000 can hold 32,000 characters in a cell - funny, cause I just read that today at work :cool: - but some formulas will not handle cells that contain more than 255 characters of text.

And definitely take a look at that link that Zack posted :thumb Good Stuff

CptGreenwood
10-11-2005, 11:01 PM
I'm using Office XP. I've found an article on MSDN about the limitations of Excel 2000. There it's been said that the maximum number of chars in a cell is about 32000 and 1024 of them can be displayed in the cell.

But with "my" excel I get that "#######" after 255 chars.

Zack Barresse
10-12-2005, 10:26 AM
That is because it cannot all be displayed in lieu of the column width.

johnske
10-12-2005, 02:19 PM
Also, check out this kb entry by byundt http://www.vbaexpress.com/kb/getarticle.php?kb_id=421 it allows more than 1024 characters per cell to be displayed and printed...