![]() ![]() It is even risky if you don’t see this error as you are not aware that you have mistakenly input a wrong date. For example, if I mistakenly type UK format, the date will be recognized as a text because there is no such month as 31. ![]() This is annoying and it causes Excel error. However whenever I work for the US company, the system defaults to mm/dd/yyyy. In the country I live, we normally use date format dd/mm/yyyy. This Excel tutorial explains how to change default Excel Date Format from Change Date and Time Format in Control Panel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |