Re: Did you know there is a pandemic going on? (1731975) | |||
Home > OTChat | |||
[ Read Responses | Post a New Response | Return to the Index ] |
|
Re: Did you know there is a pandemic going on? |
|
Posted by AlM on Sun May 24 11:05:08 2020, in response to Re: Did you know there is a pandemic going on?, posted by Stephen Bauman on Sun May 24 06:51:08 2020. I presume Excel does the same.No, if I enter -5000 into Excel, and then format as a date, I get a string of # signs, no matter how wide I make the column. I've actually come across that problem in real life at work. Someone must have mistyped a DOB as 18xx instead 19xx as input into a system that could tolerate that (probably Cobol on an IBM mainframe), and then when the data was imported into Excel, formulas referencing that cell went nuts. I should ask someone who was an actuary in the 1980s how they handled DOBs in the 19th century. I know my company used to use Lotus until the mid-90s. Pension liabilities for retirees would not have been calculated correctly in 1985 if you had just defaulted every 19th century birth to 1/1/1900. |