Convert Text-Formatted Dates to Actual Dates in Excel

This video shows how to convert text-formatted or text data type dates into actual or real dates in Excel.

[@giuliovivaldi]

you are great! thank you ! If I become rich I am gonna remember you!

[@jyimata171]

What if with time likr dec 7 2023 9:30 am thanks how to convert to date and time format . Thanks for your answer

[@ExcelInsights]

Does Excel read this as text?

[@jyimata171]

Yes read it as text

[@jyimata171]

I have tried it is working . My problem now is the time how could it do that please help

[@jyimata171]

Thanks in advance for your help 😊

[@jyimata171]

I already find solution . Thanks . I just separated the time then after ive dined coverting the text to date i just added the date to time 😊 but your video was been very helpful 😊