how do i enter 16-22 november, 2009 as a date in excel 2003
Joel,
You have done something strange with your message, in that you've included
your new material as if it were part of what you've quoted from Kassie.
The thing which determines how Excel interprets dates is not "different
versions for different countries". It's determined by the Windows Regional
Options, set through Control Panel.
--
David Biddulph
joel wrote:
Kassie;528816 Wrote:
16/11/09 in one column, 22/11/09 in the next
Now finally a good question. A US member of the USMC trying to
enter a date in International standard (Day/Month/Year). Now that
is a problem. Excel has different versions for different countries.
The US version won't recognize the International dates, and the
Internation version of Excel won't recogmize the US dates.
the US version will only recognize an input in US format of
month/day/year, but will automaticaly convert to International
standard is you change the format of the cell(s).
Use the worksheet menu to format the cell as follows
Format - cells - Number - Custom
Then in the box type either d/m/yy, dd/mm/yy
Excel will automaticall reverse the month and date after you enter
the date.
|