Hello everyone,

First of all i want to thank everyone for the help they provide here.

I am facing difficulties in retaining the number format in excel sheet.
Example: I am pasting the number ‘123456789112345789’ to excel cell but displays as this ‘1.23457E+17’ then again I mail merge this number to word and it gives me the output as ‘1.23457E+17’. I want to have my end result in merged doc as ‘123456789112345789’ not the changed one.

Can anyone help in solving this for me?

Thank you

p.s: sometimes the number copied has letter in between them.