Need an Excel Expert for Mac regarding import of csv files
Budget: €30 – €250 EUR
We are downloading our weekly bank statement as csv files.
Unfortunately, the debit amounts are not listed as negative amounts. In order to import them into our system we need to amend the files by adjusting the debit amounts with a minus sign.
The trouble with the Mac is, that after changing the file, the application somehow saves a different file format or changes something in the background which messes with the entire file. Other attempts to go around this issue didn't work either. It all comes back to being an issue with the MacBook.
Unfortunately, the debit amounts are not listed as negative amounts. In order to import them into our system we need to amend the files by adjusting the debit amounts with a minus sign.
The trouble with the Mac is, that after changing the file, the application somehow saves a different file format or changes something in the background which messes with the entire file. Other attempts to go around this issue didn't work either. It all comes back to being an issue with the MacBook.