Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!dali.cs.montana.edu!uakari.primate.wisc.edu!caen!spool.mu.edu!uunet!munnari.oz.au!metro!utsmips!uts-phys.phys.uts.EDU.AU!thomas
From: thomas@uts-phys.phys.uts.EDU.AU (Thomas Brodhurst-Hill)
Newsgroups: comp.sys.mac.apps
Subject: Excel date fomat. Help.
Keywords: Excel
Message-ID: <968@utsmips.csd.uts.EDU.AU>
Date: 5 Jun 91 03:31:42 GMT
Sender: news@utsmips.csd.uts.EDU.AU
Distribution: all
Organization: University of Technology, Sydney, Australia
Lines: 13
Nntp-Posting-Host: uts-phys.phys.uts.edu.au

Help

I'm using Excel 2.2a with system 6.07 (international:Australian).

My problem is best illustrated by an example:

1)	Into a blank cell, I enter "Jun 5"
2)	Excel shows the date in the formula bar in American format: "6/5/91..."
3)	I then wish to change the date to the 4th so I enter the formula bar and select the 5 and type "4".
4)	Excel now changes the date to be "4/6/91..."
5)	Any subsequent editing of the date in the formula bar toggles it between Australian and American format. This is insane. Help!

Tom