G
Guest
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?
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?