Exported number fields display in exponential format in excel
|Knowledge Article Number||000004377|
If you export the number fields from Salesforce, they can appear in exponential format in excel if they contain more than 12 digits.
To resolve this in excel you can follow either of the following steps:
2). Expand the width of the column that contains the numbers.
a. Highlight the column in question.
b. Right click and select Format Cells
c. Choose "Number"
d. Click Ok
Either steps should make the column display the number in a number format, i.e 123456789123 vs 1234E+5