In Excel, formatted scientific notation field is displaying 0 for last digit
I have exported Salesforce data into a Excel (please see attached). The Credit Card No. field exported in scientific notation. When I click on any of those cells, the last digit has been changed to 0, or if I convert that column to a different format the last digit of each credit card numbers is 0. However, when I import the data back into Salesforce, the last digit imports correctly (not 0).... so I know the correct data must be in the Excel file, I just don't know how to see it.
How can I view the Credit Card No. column without the last digit displaying 0 for all the rows?
Thanks,
Burt
|