Forum Discussion
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
9 Replies
How these dates are added, do you open csv file to take them?
SergeiBaklanI'm not too sure as I didn't add them in. I think they came from a report downloaded from our website but would likely have been excel or csv
When most probably csv. Are you on Excel 365?
What happens with dates with a day number > 12?
- They are formatted correctly for some reason, it's just the ones 12 or less that do this.
