1. In the Excel (CSV) import file, highlight the amount column (excluding the header).

2. Select Format, Cells from the menu bar.

3. On the Number tab, highlight Number.

4. Mark and then unmark the Use 1000 Separator (,) checkbox.

5. Click OK.

6. Delete the dollar sign from all numeric fields.

7. Save and Close the import file.

8. Validate and import the transactions.