Hi all. I have been downloading bank statements as a csv file to excel. Everything was ok when they had separate columns for debits and credits. I would sort the data, copy it and paste it into my main programme.
Now they changed it so all debits and credits are in the same column. To make matters worse they have the debits as negative numbers.
What I want to do is separate the column into two columns Debit and Credit, then convert the negative numbers to positive. I need the new figures to be in the same row as the original row because of the details of the transaction need to line up with the amount. It would need to be a vba formula I assume.
Thank you in advance for any advice.
Regards Evfred
Now they changed it so all debits and credits are in the same column. To make matters worse they have the debits as negative numbers.
What I want to do is separate the column into two columns Debit and Credit, then convert the negative numbers to positive. I need the new figures to be in the same row as the original row because of the details of the transaction need to line up with the amount. It would need to be a vba formula I assume.
Thank you in advance for any advice.
Regards Evfred