Forum Discussion
emmabellu
Aug 21, 2024Copper Contributor
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 ...
HansVogelaar
Aug 21, 2024MVP
What happens with dates with a day number > 12?
- emmabelluAug 21, 2024Copper ContributorThey are formatted correctly for some reason, it's just the ones 12 or less that do this.