Excel date format

Article View: comp.sys.mac

Article #13413

#13413

From: Thomas Brodhurst-Hill
Date: Mon, 03 Jun 1991 01:11

25 lines
1208 bytes

I'm using Excel 2.2a (Hopefully 3.0 soon) for student records, timetabling etc. When I edit a cell containing a date format, the date value toggles between Australian and American format. For example:

Say a cell contains:

3/6/1991 3:00 PM

I click in the formaula bar to edit it, change nothing, then hit enter.

The cell now shows:

6/3/1991 3:00 PM

A subsequent edit toggles it back again!

Excel always interprets the date as American format, so if the Number format for the cell is "d mmm yy", the cell will show respectively:

6 Mar 91

and

3 Jun 91

This is driving me insane! Please help, email or post. Thanx,

Tom

Technical Details

Message-ID: <963@utsmips.csd.uts.EDU.AU>

Path:

arc1-ca.pugleaf.net!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

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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
Subject: Excel date format
Keywords: Excel,date,help
Message-ID: <963@utsmips.csd.uts.EDU.AU>
Date: 3 Jun 91 01:11:36 GMT
Article-I.D.: utsmips.963
Sender: news@utsmips.csd.uts.EDU.AU
Distribution: all
Organization: University of Technology, Sydney, Australia
Lines: 25
Nntp-Posting-Host: uts-phys.phys.uts.edu.au