E Eva Cheng New Member Feb 5, 2025 #1 how to convert a text '12 May 24' to a date format in Excel, thanks Eva
AliGW Well-Known Member Feb 5, 2025 #2 What's your locale? Here in the UK it converts automatically. You could try Data | Text to Columns > Next > Next > select DMY > Finish. Attach a sample workbook.
What's your locale? Here in the UK it converts automatically. You could try Data | Text to Columns > Next > Next > select DMY > Finish. Attach a sample workbook.
E Eva Cheng New Member Feb 5, 2025 #3 I am in Hong Kong. I have tried before but don't know exactly how to do. Now re-try, it works. Thank you !
I am in Hong Kong. I have tried before but don't know exactly how to do. Now re-try, it works. Thank you !