Wrong Date format

[suhabthan]

Hi guys,

I have excel sheet with wrong date format , i need to change that format as per regular rule, pls give some ideas on it.

Wrong date format	Correct date format
01/01/2018	01/01/2019
01/02/2018	02/01/2018
01/03/2018
01/04/2018
01/05/2018	05/01/2018
01/06/2018
01/07/2018
01/08/2018
01/09/2018
01/10/2018
01/11/2018
01/12/2018
1/13/2018 12:00:00 AM
1/14/2018 12:00:00 AM	14/01/2018
1/15/2018 12:00:00 AM
1/16/2018 12:00:00 AM
1/17/2018 12:00:00 AM
1/18/2018 12:00:00 AM
1/19/2018 12:00:00 AM
1/20/2018 12:00:00 AM

Thnx

 

[James006]

Hi,

The main question is to determine whether you are dealing with Text or Values ...

 

[Fluff]

Select the column > Data Tab > Text to columns > Delimited > Next > Uncheck all boxes > Next > Date & select MDY > Finish