New
#1
microsoft date formats
I like to have my regional settings as follows:
dd-mmm-yy (or yyyy), such as today: 04-nov-13 (this is because I live overseas, and constantly get confused about what I'm seeing between US/UK format).
however, I want to always input as US format (eg. 11/4 for the above example). in other words, I want US settings, but just only to tinker with display format.
my regional settings are "english (united states)", and short date "dd-MMM-yy" for example.
and in excel, the default date format is "*14-03-01".
how to accomplish this without having to change settings everytime I open a new worksheet?
thank you
-patrick