Forum Discussion
Date format conversion USA / UK
I am in the Uk and enter a date in USA format into a cell of type ‘general’ e.g. for 11-FEB-2017 I enter 02/11/2017. I save the file and email it to USA. When opened in the USA excel has changed the f...
Hi Barbara,
First and foremost, you have to know that the date format in Excel is based on the date setting in Control Panel of your OS.
I think that the date format in your OS is: (dd/mm/yyyy), since you live in the UK.
So, you have to write the dates in this format or use the universal method: (yyyy/mm/dd) which converts the date to your local date setting whatever its format.
Don't use the USA format, because your local date setting isn't based on that format.
When you write 02/11/2017 and your local OS date setting is: (dd/mm/yyyy), that means 02/Nov/2017.
Thanks so much for the answer been hitting a wall re this issue. You just solved the issue I've been having!