View Single Post
  #3   Report Post  
Old January 11th 05, 08:36 PM
Chip Pearson
 
Posts: n/a
Default

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.