View Single Post
  #1   Report Post  
berryware421243
 
Posts: n/a
Default Long numbers show up as Scientific Notation

Hello,

We have a web based asset tracking system, and some assets have long serial
numbers; for instance,
3100600300030147987
or
3101600300100020220

When we import, cut and paste, or open an HTML format page in Excel with
these serial numbers, they all show up as: 3.1016E+18 and the last 6 digits
get rounded up.

How do we show the correct value for these long numbers in excel?

Thanks