MS Excel 2002 - Text Field Size Limit

[ConQueso 0]

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?

[jimbo 0]

Excel XP can only have a maximum row height of 500 and cell width of 255. If your text exceeds that then you are out of luck.

[ConQueso 0]

Thanks for the reply.

 

My cell height though isn't even at 500, nor the width 255, though. Any ideas?

[AndyFair 0]

You've got wrap text on?

 

Rgds

AndyF

[Dudemeister 0]

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?

[ConQueso 0]

Hmm...

 

That's likely it. I'll try to find out for sure and post back later.

 

Thanks for the responses.