Using Excel, it unfortunately looks as though your bank's CSV file is poorly formatted.
The transaction amount values (column E) are all positive values. There is a 'DR' or 'CR' designation in the adjacent column (column F) which I believe distinguishes 'Payments' from 'Deposits'.
You'll need to edit the file in Excel (or your spreadsheet of choice) before importing it.
An easy solution is to enter the following formula into Cell G2.
Drag it (auto-fill the formula) down the length of Column G equal to the number of transaction values.
Doing so, will create positive and negative values down the length of Column G dependent on the text "DR" in Column F.
Exit the spreadsheet saving the changes. Due to the restrictions of CSV files, the formula will be lost but the positive and negative values should remain.
You should then use the Text Importer extension to import the file. Use the newly created positive and negative values (Column G) to populate the 'Amount' field of the Text Importer. If you need help with the Text Importer extension, post back and I'll try to lend a hand.
I would look to see if your bank offers any other file formats. CSV is often not the easiest format to deal with as it is so generic. Formats like OFX, QFX, OFC, QIF are much easier to deal with as they are intended for financial information and Moneydance handles their import.