I think i lack means 100000 (in Indian English) .
Isn't it Enni.
well, if this is what you meant then sorry, transpose will not work even in
excel 2007.
I'll give you a work around.
Copy the complete the column and paste in in notepad
now copy the data in notepad
and paste it in one cell in excel (double click a cell or select the cell
and press "f2" and then paste)
now use the formula
=SUBSTITUTE(A1,CHAR(13)," ")
you have the complete numbers in one row delimited by a space.
now you can copy the data to notepad.
Finally, pls reply i was in the right direction or my answer went haywire.