Thanks Gord,

I may have to distribute the content to few cells.

Jerry


"Gord Dibben" wrote:

Jerry

First...............A worksheet has many cells. Why are you pounding so
much into one cell? You have eliminated any use of sorting or filtering or
just about any other function.

Second.................the Alt + Enter should work if you place one every
100 chars.

Third................are you dealing with merged cells? These will disable
the row autofit and must be dealt with manually or through VBA code.

Maybe a textbox would serve you better if you need all that info in one
cell.


Gord

On Sun, 14 Jun 2009 19:27:01 -0700, Jerry AMK
wrote:

Sorry, maybe I describe it wrongly.
I have a cell filled with group of invoice numbers (i.e: 7171, 82426,
827782133007116, 2133007238, ...) and it maybe more than 1000 characters in
that cell. I saw your earlier post for other's similar questions and you
mentioned about 1024 character limitation. Maybe I have to accept this
condition?
I also try Alt+Enter but it good if only for few times.

Thank you,
Jerry

"Gord Dibben" wrote:

You say "many" numbers in a cell.

Then you say "4 digits to 10 digits"

That doesn't seem like many to me and would not require the use of wrap
text.

Have you misstated what the cell contains?

Maybe many groups of numbers with 4 to 10 digits in the cell?


Gord Dibben MS Excel MVP


On Sat, 13 Jun 2009 01:42:01 -0700, Jerry AMK <Jerry
wrote:

Hi,
I have cell filled with many numbers (4 digits to 10 digits) and the cell
format is general wrap text, but when view/print the content not showing all
the numbers, even after increase the row height.
I am using Excel 2002.
Any setting I missed out or is it limited to certain maximum charactes in
one cell?
Thanks,
Jerry