Topic starter
My colleague has sent me two documents, when I open them (read only etc) the date has been reversed - from Uk (D/M/Y) format to US format (M/D/Y). However when I go to format it says its in UK format. We open the same doc on his PC and its the correct format. WTF is going on? How can I fix it?
Posted : 10/09/2019 10:31 am
What regional setting is your PC configured with?
Posted : 10/09/2019 10:33 am
Topic starter
How do I check that?
Posted : 10/09/2019 10:42 am
Just format the cells.
Select, right click, format cells, date. Choose the region or the format required.
Posted : 10/09/2019 11:00 am
Depends on the version of Windows you have but via Control Panel or Windows Settings and you'll have a Region option and within that should be date format - as far as I know Excel uses your operating system region date format rather than having it's own.
Posted : 10/09/2019 11:01 am