I am brand new to Excel and am having trouble formatting a date. We have
different nationalities in the office where each person enters the date
differently:
* month, day, year
* year, month, day
* day month year

Everyone defaults to their own country's way of doing things and we are
getting very confused! To eliminate confusion, for example, I've formatted a
cell "mmm-yy". But if someone enters "11-06" (for November 2006) the value
becomes "Jun-06". Entering "9-07" (September 2007), it becomes Jul-06". If I
enter "2007-8" it remains unchanged. The only time it works is if you
actually enter the short-form month and year (Feb-07), which is kinda missing
the point of formatting the cell to begin with. What is the best way around
this?