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.

Excel for Mac

1. Open your file in Excel.
2. Choose Excel, then Preferences.
3. Choose Edit.
4. Clear Use system separators.
5. Set Decimal separator to ..
6. Set Thousands separator to ,, then close Preferences.

Excel for Windows

1. Open your file in Excel.
2. Choose File, then Options.
3. Choose Advanced.
4. Under Editing options, clear Use system separators.
5. Set Decimal separator to ..
6. 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.