All Collections
Manifests
How To
Formatting numeric columns in CSV Files
Formatting numeric columns in CSV Files

This article describes how to correctly format your numeric columns like UPC before uploading CSV files.

Nizar Noorani avatar
Written by Nizar Noorani
Updated over a week ago

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, follow the below instructions:

  • Expand the column so that the entire value is visible

  • Select the entire row

  • Right-click and from the dropdown that you see, select the 'Format Cells' option

  • Select the 'Number' option and change the 'Decimal places' to 0

  • Save the file as a .csv file

Checkout the video below to see in action:

Did this answer your question?