1. Open the excel file
2. Format each amount column as text
3. Remove any dollors signs or commas
4. Save the file in .csv format
5. Reopen the import and import the information.