View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Jerry AMK[_2_] Jerry AMK[_2_] is offline
external usenet poster
 
Posts: 4
Default Cell format - wrap text

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