Hi all,
I have just changed banks and when I d/load the statements they come as a CSV file. The issue is the debits and credits are all in one column so when it is a credit it is a positive number ie. 2.98 but a debit is shown as a negative number ie -2.98. I was wanting to leave all the +ve values in one column and move all the -ve values to the next column so I can sum the columns for my accounts.
Any help would be very well received.
Thanks in advance
Ali G
Bookmarks