In New Zealand, we format our dates dd/mm/yy. However, the United States format as mm/dd/yy.
When I see a date by itself, like 12/01/09, I ask “is this the 12th of January or the 1st of December”?
When I started working with Oracle RDBMS, a habit I picked up was to format dates dd-mon-yyyy.
This avoided the dd/mm [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/12/23/date-formatting-and-regional-settings/
Posted
Dec 23 2009, 03:29 AM
by
Daily Dose of Excel