Date issue.

[drjpb]

Facing an issue with statements received on monthly basis.
The period from 01-12 of days are considered as months, no issues with the period from 13-31.

No matter which format i select, i still face same problem. Resulting me to enter the dates manually to fix it.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]#[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]03/01/2015[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]03/02/2015[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]03/02/2015[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]03/04/2015[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]03/05/2015[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]03/10/2015[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]03/11/2015[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]03/11/2015[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]03/12/2015[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]14/03/2015[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]14/03/2015[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]15/03/2015[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]16/03/2015[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]16/03/2015[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]16/03/2015[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]16/03/2015[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]17/03/2015[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]17/03/2015[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]19/03/2015[/TD]
[/TR]
</tbody>[/TABLE]

Average no. of transaction monthly are around 1k.

The excel file which i receive is being generated from Oracle Web Application.
I have done everything from my side but couldn't find a permanent solution for it.

Also how i can upload the sample excel file? Which web service do you suggest for sharing the file.

Thanks in advance.

 

[dmt32]

Hi,
give this a try & see if helps you:

Select the column containing your dates

Choose Data > Text to Columns…
Select "Delimited" > click Next
Uncheck all delimiters > click Next
Select data column format "Date: DMY" > click Finish

Dave

 

[Lokesh_kumar]

Hi,
I just copy paste data from here and see that some of the cells have date format and others cells having General format. Please change general to date.

 

[drjpb]

Thanks dmt32 & Lokesh_kumar, i tried it but unfortunately not working.
Any more suggestions, i believe it requires some sort of macro to convert in one go.


Sorry for the late reply, was busy in monthly closing.

 

[drjpb]

Any suggestions guys?
Thanks