Hi Mahesh,
You are right my excel hasin some rows i checked it has / instead of -.
dd/mm/yyyy instead of dd-mm-yyyy
Hi Mahesh,
You are right my excel hasin some rows i checked it has / instead of -.
dd/mm/yyyy instead of dd-mm-yyyy
Hi Mahesh,
I got the problem
the problem is in my transaction date column half of the format is like mm-dd-yyyy and half is like
dd/mm/yyyy. the place from where the / is starting the date format is only getting cahnged
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-01-2017 00:00
12-02-2017 00:00
12-02-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-04-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-05-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-06-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-07-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-08-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-11-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
12-12-2017 00:00
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
13/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
14/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
15/12/2017 12:00 AM
ok try with the procedure mentioned above and check whether it is working or not.
Regards,
Mahesh
sure mahesh.