Nora, You aren¹t doing anything wrong, but Excel doesn¹t natively handle dates prior to 1900. I can¹t say from experience, but I did do some reading and here is some background info and a few possible workarounds depending on what you want to do with the date information.
http://www.exceluser.com/explore/earlydates.htm http://www.pcmag.com/article2/0,2817,2114548,00.asp http://j-walk.com/ss/excel/usertips/tip028.htm Good luck! -- Beth Phillips From: <[email protected]> Reply-To: <[email protected]> Date: Wed, 18 Jan 2012 12:00:02 -0500 To: <[email protected]> Subject: MacGroup Digest, Vol 33, Issue 18 Send MacGroup mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://www.math.louisville.edu/mailman/listinfo/macgroup or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of MacGroup digest..." Today's Topics: 1. Excel (Nora Probasco) _______________________________________________ MacGroup mailing list [email protected] http://www.math.louisville.edu/mailman/listinfo/macgroup
_______________________________________________ MacGroup mailing list [email protected] http://www.math.louisville.edu/mailman/listinfo/macgroup
