
This Excel tutorial explains how to change default Excel Date Format from Change Date and Time Format in Control Panel.
How to Change Default Excel Date Format
In the country I live, we normally use date format dd/mm/yyyy. However whenever I work for the US company, the system defaults to mm/dd/yyyy. This is annoying and it causes Excel error. For example, if I mistakenly type UK format 31/12/2019, the date will be recognized as a text because there is no such month as 31. It is even risky if ...
Read More