I found the link below which provides a comprehensive discussion of the Excel issues with dates and work arounds.
http://www.exceluser.com/formulas/earlydates.htm I am sure there are other discussions and work arounds. This was just one of the more comprehensive discussions that I found. Hope this helps. Jim Sent from my iPhone > On Jun 12, 2017, at 8:53 AM, Brian Kelly <[email protected]> wrote: > > There is(or used to be) an Excel Add-on you can install for pre 1900 dates > but in its raw form versions of Excel up to 2007 did not understand dates > before 1 Jan 1900. Dates were stored internally as the number of days since 1 > Jan 1900. If your Excel is working for dates before 1 Jan 1900 check your > installed add-ons or which tell us which version of Excel are you using. > > Brian Kelly > >> On 12-Jun-17 10:35 AM, Pete Beatty wrote: >> Michele, your current tip contains the following: "Excel can't handle >> pre-1901 dates so you will have a problem sorting by columns." >> Excel Does not have a problem with dates prior 1901. It can handle all >> formats of dates. I have several spreadsheets with some having thousands of >> records with dates ranging between 0900 and present. I can sort, and filter >> all records correctly. >> Perhaps you are referring to dates with prefixes. We sometimes think items >> such as "bef" Or "c" as dates. Technically they are not components of a >> date. When you add them to a date, they are interpreted as a character >> string, not a date. As a character string, the entries are not sorted as a >> date. >> If this is the case, then excel can still properly sort. You may have to >> define a format, a relatively simple process, or perform a simple cleanup. >> Pete > > --- > This email has been checked for viruses by AVG. > http://www.avg.com > > > -- > > LegacyUserGroup mailing list > [email protected] > To manage your subscription and unsubscribe > http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com > Archives at: > http://www.mail-archive.com/[email protected]/
-- LegacyUserGroup mailing list [email protected] To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/[email protected]/
