It looks like you're new here. If you want to get involved, click one of these buttons!
Date issue while importing bank statements
edited July 2014
I imported a fresh bank statement in an excel sheet from Karnataka Bank and saved it as Excel 1997-2003 format.
I tried to import, but the dates are not correct.
There is some issue with the date format in the file. It seems that you have saved the original file again and the format of some of the dates have changed to US format.
To resolve this, you need to do the following:
1. In Windows, click on Control Panel
2. Select Region
3. Select, Format ‘English (United Kingdom) and short date ‘dd/MM/yyyy’
4. Click Apply and save this
5. Restart your computer
6. Then download the bank file again and import it
Powered by Vanilla