How to Convert a excel column to date time format

[manojmanu.rpa]

Hi Team , i have an excel sheet with date column in an incorrect format see below image
input:

and i need an output in this format

Please help with this scenario.

Thanks,
Manoj

[putera.timmy]

Hi, you can try this

dt_clone = dt_1.AsEnumerable.Select(Function(r) dt_1.Clone.LoadDataRow({DateTime.ParseExact(r(0).ToString.remove(0,4), “MMM dd HH:mm:ss yyyy”, System.Globalization.CultureInfo.InvariantCulture).tostring(“MM/dd/yyyy HH:mm:ss”),r(1)},False)).CopyToDataTable()

[Anil_G (Anil Gorthi)]

@manojmanu.rpa

You have an activity call format cell which can format the cell to the required date format.Please try that

Format Cells

Cheers