Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!think.com!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: Re: Excel date fomat. Help.
Keywords: Excel
Message-ID: <990@utsmips.csd.uts.EDU.AU>
Date: 13 Jun 91 02:03:47 GMT
Article-I.D.: utsmips.990
References: <968@utsmips.csd.uts.EDU.AU> <1607@aoa.UUCP>
Sender: news@utsmips.csd.uts.EDU.AU
Distribution: all
Organization: University of Technology, Sydney, Australia
Lines: 53
Nntp-Posting-Host: uts-phys.phys.uts.edu.au

Thanx to the people who replied to my Excel Date format problem.

The most effective solution that I've been given appears below.

From peter@phadfa.ph.adfa.oz.au  Thu Jun  6 12:25:07 1991
Received: from sserve.cc.adfa.oz.au by uts-phys.phys.uts.EDU.AU (5.52/900605.SGI)
	(for thomas) id AA00691; Thu, 6 Jun 91 12:25:07 EST
Received: from phadfa.ph.adfa.oz.au by sserve.cc.adfa.oz.au (5.65b/1.34)
	id AA09612; Thu, 6 Jun 91 11:25:02 +1000
Received: by phadfa.ph.adfa.oz.au (5.65+/1.34)
	id AA26184; Thu, 6 Jun 91 11:24:58 +1000
Date: Thu, 6 Jun 91 11:24:58 +1000
From: peter@phadfa.ph.adfa.oz.au (Peter Lynam)
Message-Id: <9106060124.AA26184@phadfa.ph.adfa.oz.au>
To: thomas
Status: RO

I too had trouble with Excel dates and got some help from Peter Marks in Sydney.

I quote:

Excel looks for the INTL resource in your system file.  The interesting one
has ID 0. The selection of sorting order chosen with the control panel
device doesn't have any effect on this.

To fix the problem, open your "backed up" system file with ResEdit and edit
the INTL 0 resource, it lets you choose d/m/y and all the formattingfor
both short and long dates. Also change the language id number to 15.

If you don't want to hack with your system, you can create the INTL resource
in Excel itself, applications find resources in themselves before they look in 
the system. 

When you make the change, everything is fixed! Datesdon't switch to mm/dd/yy
when you press enter, and Format;number dialog has a number of nice default
formats for Australian dates in there.

I have hacked both my system and Excel as indicated above and am very pleased 
with the result. I run System 6.0.2 but suppose the hacking should work with
6.0.7. The other advantage is that &D in Page Setup now gives the date
automatically in Australian format.

Happy hacking,

Peter.

Thanx again for your replies.
Tom

PS I started implimenting this change using Resedit 3, but it kept crashing when I changed the info of a resource. Resedit 1.3 worked fine.

Tom