On Fri, 19 Aug 2005 03:41:02 -0700, Natman
wrote:

Thanks for your reply Mangesh, you are correct it does work that way, however
I think in previous versions of excel I have been able to enter it the other
way (ie. the Australian way).

It may be a Windows setting and not an Excel format issue.

Check Start/Control Panel/Regional Settings. Excel should parse your date
entry per the format of the short date at that setting.


--ron