First of all make sure that there no special characters or symbols before or after the value within the cell in each row and every column.
Once you've ensured that there are no special characters or symbols in any cell within the report under any columns,
steps that needs to be followed before saving your file as a .csv (comma delimited)
Step 1: Most essential, expand the column
Step 2: Select the entire column
Step 3: Right click the from the drop down select the Format Cells... option
Step 4: Select the Number option and change the Decimal places to "0"
Step 5: Click the Ok button
Step 6: Ensure the column is still expanded
Step 7: Click the save / save as file option
Step 8: Make sure you're saving the file as .csv (comma delimited)
Step 9: Click the Save button