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 ...
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?
SergeiBaklanYes it's 365
