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

Did this answer your question?