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...
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.