Paste Speciale

[tinferns]

Am trying to paste the below numbers on Excel and numbers are getting automatically rounded off .. tried pasting special as HTML, Unicode Text and Text.. still the same..

Original number:

4479951606949707


When pasted (Normal/ Special) changes to

4479951606949700

Is there anyother special way of pasting ??

 

[bensonsearch]

could be the format of the cell you are pasting into. is it set to text?

 

[tinferns]

could be the format of the cell you are pasting into. is it set to text?

Thanks for the above reply.. besides changing to text after pasting u get a small paste option box, you need to select MATCH DESTINATION FORMATTING..

Thanks

Martin