Hi everyone,
I'm from Australia and we use an accounting software that can export data in excel format which is fine.
However, when I want to work with the data in the cells the cells don't work, like if the export gave them a weird format that I can't see and I can't get rid of.
I have tried everything, copy/paste special, copy/paste to new excel sheets, trim, concatenate, &, clear format and I cant solve the problem.
Please find attached 2 files showing a small example.
1. MYOB sample - is the file I am working with column A and B, and the rows 7 - 12 have this weird problem but rows 15, 16 and 17 work just fine
2. COASUM1 - MYOB - is the actual export from this software called MYOB
If someone could help me making rows 7-12 workable for sumifs and vlookups I would really really appreciate it
All the best,
Bookmarks