Need help converting date

[Rohan Thatte]

Hi Guys,

Please help me convert this dates which I have received in a .csv formatted file. When checked its length it appears to be equal to 5. This particular column had dates in various inconsistent format, I was able to handle the others only this one is creating problems. Kindly find attached file, I have written into it what am i expecting for this.

 

[kamal bhatt]

Hope this helps.. Cheers

 

[rahulshewale1]

Hi @Rohan Thatte ,

See if is ok ?

E2: =TEXT(A2,"mm-dd-yyyy")+0 and Change Number formatting as date ( CTRL +SHIFT + #)

Regard
Rahul Shewale