lastpass import csv number format goes exponential

I came here to report the same issue. Tertius3's answer is spot on. I had exported my data from LastPass, but for some reason LastPass had duplicated all of the entries in the csv, so I opened it in Excel, removed duplicates, and saved it. That must've been what converted the large numbers to the scientific exponent format. Unfortunately since the numbers were converted before importing into 1Password, you can't automatically get the original number back. You need to find your original number and manually update it in 1Password. Thanks!