Pricing

Format Cost and MAP Columns for Upload

Rocket Source reads a period as the decimal separator and a comma as the thousands separator. Use 1,234.56, not 1.234,56.

Change this

1.234,56

To this

1,234.56

The warning in Rocket Source

When you start a new scan, Rocket Source checks the first rows of your Cost and MAP columns. If a value uses a comma as the decimal separator, you see a warning with the value it found.

New Scan window on the Upload File step, with an orange warning that the uploaded file contains the value 12,50 with a comma as the decimal separator — If your file has Cost or MAP headers that Rocket Source recognizes, the warning shows on the Upload File step.

New Scan window on the Map Columns step, with the Net Each column mapped to Cost, the Floor Price column mapped to MAP, and an orange warning about the value 12,50 — If your headers are different, the warning shows on the Map Columns step after you map a column to Cost or MAP.

Fix the file with the steps below, then upload it again.

Excel for Mac

Open your file in Excel.
Choose Excel, then Preferences.
Choose Edit.
Clear Use system separators.
Set Decimal separator to ..
Set Thousands separator to ,, then close Preferences.

Excel for Windows

Open your file in Excel.
Choose File, then Options.
Choose Advanced.
Under Editing options, clear Use system separators.
Set Decimal separator to ..
Set Thousands separator to ,, then select OK.

If your values are text

If changing the display does not update your values, add a temporary column next to Cost or MAP. For a value in A2, enter =NUMBERVALUE(A2, ",", "."). Fill the formula down, copy the new column, then paste values over the original column.

Check a few rows before uploading. This conversion is for values that currently use a comma as the decimal separator.

Microsoft's guide includes screenshots of the Windows separator settings: Change the character used to separate thousands or decimals.