I am struggling to import cashbook batches into pastel.
It seems that it is an Office 365 or Windows 8 issue, as once I have opened the batch in excel and do the text to coloms, save it and then try to import I get the following:
Line 1: Date must be in the format DD/MM/YYYY
Line 1: Invalid Date
Line 1: GDC field must be G.......
Line 1: Contra account must be this cash book.....
This problem is exactly the same on 2 different machines running Win 8 & Office 365
I don't have this problem on a Win7 machine running Office 2012.
Does anyone have the same problem?