How do I convert this date please?

I have extracted some data from a report which contains a date format I am unable to format to UK format e.g. Day, Month & Year

I've tried data to columns formatting the data as d,m,y
Also tried formatting it as UK via special text

I would be much obliged if someone could help please. I've attached a small amount of data in excel form

This is how it appears in the report. Interestingly, the CRM suppliers can't sort it out

Event Date
03/25/2024 15:17:00
03/25/2024 15:17:00
03/25/2024 14:33:00
03/25/2024 14:31:00
03/25/2024 14:21:00


Thank you
Rich

Hi there,

Try entering the following formula in Cell B2 and copying it downwards:

Please Login or Register  to view this content.

You should then format the formula cells as "dd/mm/yyyy hh:mm:ss"


Hope this helps - please let me know how you get on.

Regards,

Greg M

Maybe

Formula:

Please Login or Register  to view this content.

Thank you Greg M and ByteMarks - both of those worked

Hi again,

Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M