Dates format as wrong locale – need to change how it is recognised
Hi,
I have dates that were added to my spreadsheet but it’s in the wrong format (US format rather than UK)
But it thinks they are UK dates so if I use More Number Formats, and change it between US and UK the date just changes to the other format which is still incorrect.
How can I tell Excel that the dates are not the format it thinks it is.
Example:
Date is 5th January 2024 – it displays in UK format as 01-05-24 and US format as 05-01-24
How do I correct the date in the cells?
I’ve tried copying the data to notepad and then copying to excel but it still reads it as the wrong format.
Many thanks,
Emma
Hi,I have dates that were added to my spreadsheet but it’s in the wrong format (US format rather than UK)But it thinks they are UK dates so if I use More Number Formats, and change it between US and UK the date just changes to the other format which is still incorrect.How can I tell Excel that the dates are not the format it thinks it is. Example:Date is 5th January 2024 – it displays in UK format as 01-05-24 and US format as 05-01-24How do I correct the date in the cells? I’ve tried copying the data to notepad and then copying to excel but it still reads it as the wrong format. Many thanks,Emma Read More
