MS Excel 2002 - Text Field Size Limit
I've got a large chunk of text in a cell, formatted to general under the numbers tab, but it won't display or print all the text, even though there is plenty of room at the bottom of the cell. The only place it shows all the text is in the dropdown fx box where you enter formulas.
I've got a large chunk of text in a cell, formatted to general under the numbers tab, but it won't display or print all the text, even though there is plenty of room at the bottom of the cell. The only place it shows all the text is in the dropdown fx box where you enter formulas.
Anyone know how to get this information to show on the sheet and also when printing?
Anyone know how to get this information to show on the sheet and also when printing?
Participate on our website and join the conversation
This topic is archived. New comments cannot be posted and votes cannot be cast.
Responses to this topic
Specifications of Microsoft Excel 2002:
32,767 characters per cell. Only 1,024 displayed in a cell; all 32,767 display in the formula bar.
Maybe this is why?
32,767 characters per cell. Only 1,024 displayed in a cell; all 32,767 display in the formula bar.
Maybe this is why?