Convert dd-mm-yyyy h:mm:ss into mm/dd/yy

[hardeep.kanwar]

Hi! Everyone

What is the Easiest way to Convert this Date and time format into Dates Format i.e MM/DD/YY

Thanks in Advance

Hardeep kanwar

[led_blunt]

Format the cell to display the date how you want it.

Right click on cell, select format cell, then date, then the format.

[hardeep.kanwar]

Format the cell to display the date how you want it.

Right click on cell, select format cell, then date, then the format.

Thanks for the Reply

I Already Try this but without success. The format will not Change

[shg]

Data > Text to Columns, Fixed Width, Next, and for the first column, Column data format, Date: DMY

[hardeep.kanwar]

Data > Text to Columns, Fixed Width, Next, and for the first column, Column data format, Date: DMY

Perfect Sir,


Thanks a Lot

[shg]

You're welcome. Would you please mark the thread as Solved?