Format the cell as Text before pasting the data.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Thuferhawat" wrote in
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
numbers in the last digit is converted to a zero and it is