Hi,
I am facing weird date error.
When I see the dates in excel, it just looks like they are left aligned or right aligned in the cell. But When I put a filter , I find few of them clubbed into yearwise and rest are as it is in lined up datewise.
Because of this my whole report gets messes up. All the date formats are in general if I check individually.
Is there a possibility that when I save the file from csv to excel 2003 format...it throws an error. I have attached screenshot of the same as well for your reference.
Please let me know what is it that could be going wrong in it.
I am facing weird date error.
When I see the dates in excel, it just looks like they are left aligned or right aligned in the cell. But When I put a filter , I find few of them clubbed into yearwise and rest are as it is in lined up datewise.
Because of this my whole report gets messes up. All the date formats are in general if I check individually.
Is there a possibility that when I save the file from csv to excel 2003 format...it throws an error. I have attached screenshot of the same as well for your reference.
Please let me know what is it that could be going wrong in it.