Excel 2002 SP-1 date formatting

[Ray]

Feel like an idiot asking this but I have tried
everything I can think of.

I like to see my dates as 14-Mar-03, I format the cell to
English (Australian) and select the style 14-Mar-01.
With all other Excel programmes I have worked with
previously I can then type in 14/07/03 (in other words
dd/mm/yy) and it appears in the cell as 14-Mar-03.
No matter what Enlish(area) format I select I can only
get 14-Mar-03 by typing in 07/17/03 (in other words
mm/dd/yy).
Has anyone else come across this and did you fix it, how?

 

[Ron Rosenfeld]

Feel like an idiot asking this but I have tried
everything I can think of.

I like to see my dates as 14-Mar-03, I format the cell to
English (Australian) and select the style 14-Mar-01.
With all other Excel programmes I have worked with
previously I can then type in 14/07/03 (in other words
dd/mm/yy) and it appears in the cell as 14-Mar-03.
No matter what Enlish(area) format I select I can only
get 14-Mar-03 by typing in 07/17/03 (in other words
mm/dd/yy).
Has anyone else come across this and did you fix it, how?

Cell formatting only affects how cell contents are displayed.

Date interpretation by Excel depends on your regional settings. In Windows XP
that would be Control Panel/Regional and Language Options/Regional Options.
You can then either change the country and all associated settings, or choose
Customize/Date and change the date formats.


--ron