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

Format the cell as Text before pasting the data.

Chip Pearson
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
paste the
numbers in the last digit is converted to a zero and it is
displayed in
scientific notation.