Article View: comp.sys.mac.apps
Article #10629Excel date fomat. Help.
From: Thomas Brodhurst-Hill
Date: Wed, 05 Jun 1991 03:31
Date: Wed, 05 Jun 1991 03:31
13 lines
1101 bytes
1101 bytes
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
Technical Details
Message-ID:
<968@utsmips.csd.uts.EDU.AU>Path:
arc1-ca.pugleaf.net!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!thomasShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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