When I paste numbers in to cells why do strange things appear?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to paste (10 digit) numbers into cells in Excel documents. However
when I do so, something like 1.7001E+11 appears. I have to manually reformat
each cell to a number then in order for it to appear correctly. I
highlighted the entire column and formatted it to being a number first, but
that doesn't matter. Any help would be appreciated.
 
Back
Top