Hi I use Pastel Bank Manager to import our petty cash expenses from excel to pastel, I use three columns date description and amount (all in Text format).
This always worked fine but recently excel has confused I save the worksheet in csv close it when I try to import it I get this bizarre error msg about file format is invalid. When I re-open the excel file the date column automatically changed to date and not text.
All other bank statement imports work fine.....
What am I doing wrong?