Format the cell as Text before pasting the data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Thuferhawat" wrote in
message
...
how do I keep 16 digit numbers as text in excel?
I format the cells as text ahead of time but when I cut and
paste the
numbers in the last digit is converted to a zero and it is
displayed in
scientific notation.