General number format is automatically applied to export data when viewed in Excel. This can cause numeric values to be shown incorrectly. You can fix this by changing the format to Number style.
Example
General number Format
Number format
Detailed Steps
Apply Number formatting
- Select the cells you want to modify.
- Right-click and select Format cells...
- In the Number tab, select the category Number.
- Ensure Decimal places is 0, and click OK.
- The selected cells will change to the new formatting style.
More information
For more information, please read this article on Export data.