E Eva Cheng New Member Today at 3:03 AM #1 how to convert a text '12 May 24' to a date format in Excel, thanks Eva
AliGW Well-Known Member 13 minutes ago #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.
