Are there any Excel experts on here?
When I download my statement in CSV i have to edit the figure in each transaction to remove the “-” from credits and add “-” for debits for it to work properly in QF banking. Is there any way I can have this done automatically to save some time?
If you open the file in excel you could put a formula in a spare column saying
=-1*C2
(or whatever the amount cell is on this line) to generate the value with the opposite sign. Drag the corner handle to fill down the whole spreadsheet, then save it back to CSV.
In addition to Paul and Ian, you could record a macro in Excel/OpenOffice/LibreOffice the first time you change your csv file. Each time you want to change the next csv file from your bank you only need to run the macro by clicking a button or typing a 2 or 3 key combination. https://www.webucator.com/article/how-to-record-a-macro-in-microsoft-excel/
I read the original post as saying the bank CSV has one column for the amount with plus and minus numbers, but the sign is reversed from what QuickFile expects.