Thanks RB Smissaert ,
but still another problem arised in between.
Your modification is working perfectly for small numbers.But for me
each cell is a 6 digit number and it is going for 50 to 60 cells.ie.

100001
122200
233333
133444
345566
......
...
upto 50 lines
So when i open the word file i am getting the output as
"#############".
Even in the cell(1) of excel sheet i am not able to set a correct
format that shows me 100001,122200,......

Your suggestion is awaited,

TIA
Roshin


--
roshinpp_77
------------------------------------------------------------------------
roshinpp_77's Profile: http://www.excelforum.com/member.php...o&userid=34924
View this thread: http://www.excelforum.com/showthread...hreadid=562026