🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac
Article #42606

Macro for date correction (MS Excel)

#42606
From: Andrew Markham
Date: Mon, 15 May 1989 20:58
20 lines
1225 bytes
  While in the process of converting PC spreadsheets to the Mac I have 
discovered a rather irritating problem.  The dates that exist in Excel 
are stored as a serial number referenced to a "date 0".  As it turns out,
the "date 0" on the Mac differs from that on the PC by 1462 days and 
therefore converting the spreadsheets results in a date change that is 4 yrs
and 1 day different.

  I am wondering if anyone out there knows of a "quick fix" for this problem.
I called Microsoft and the man told me that I could "cut and paste" my way
back to normality, but I kinda doubt that I am going to do this to the 100+
spreadsheets that are going to be converted.

Any and all help will be appreciated.


Andrew W. Markham 			<markham@sunmail.cs.unc.edu>
Undergraduate Assistant
Computer Science Department
University of North Carolina at Chapel Hill
Technical Details
Message-ID: <8134@thorin.cs.unc.edu>
Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!mcnc!thorin!rho!markham

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!mcnc!thorin!rho!markham
From: markham@rho.cs.unc.edu (Andrew Markham)
Newsgroups: comp.sys.mac
Subject: Macro for date correction (MS Excel)
Keywords: Excel, Macro, date correction
Message-ID: <8134@thorin.cs.unc.edu>
Date: 15 May 89 20:58:54 GMT
Sender: news@thorin.cs.unc.edu
Lines: 20