Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!bbn.com!aoa!rich
From: rich@aoa.UUCP (Rich Snow)
Newsgroups: comp.sys.mac.apps
Subject: Re: Excel date fomat. Help.
Keywords: Excel
Message-ID: <1607@aoa.UUCP>
Date: 6 Jun 91 16:10:42 GMT
References: <968@utsmips.csd.uts.EDU.AU>
Reply-To: rich@aoa.UUCP (PUT YOUR NAME HERE)
Distribution: all
Organization: Adaptive Optics Assoc., Cambridge, Mass.
Lines: 39

(Thomas Brodhurst-Hill) writes:
>
>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!

I have the same problem with Excel 2.2 & System 6.05 here in the USA. 
When you set the number format of a cell to d/m/yy - as you edit the 
info in the formula bar, the changes are posted to the wrong item
in the cell (d>m, m>d).

A workaround...

First make sure you have full menus enabled. Look under options
-if it says "short menus" at the bottom, full menus are set OK. Now
while you're under "Options" select "Calculation". In the calculation 
dialog box if you turn off 1904 date system, the problem seems to go away.
Now it toggles date formats in the cell until you hit enter, 
but once you enter it the data is OK.

You still have the problem that the formula bar insists on using US
date format. But what you type goes to the correct spot in the cell.
Also any macros that depend on the 1904 date system will need to
be modified.

Can anyone try this out with Excel 3.0?

-Rich
-- 
*	Rich Snow  AOA-----------------*
*       (617)864-0201
*	rich@aoa.utc.com   Disclaimer: Lack of Disclaimer.
*       aoa!rich@bbn.com