Excel中有关于日期的错误吗? [英] Is there a bug in Excel concerning dates?
问题描述
请不要问我是怎么偶然发现的,但请尝试以下操作:
Please don't ask how I stumbled upon this but please try the following:
- 在Excel中单元格中输入60
- 将数据类型设置为日期格式
- 显示的日期(至少在我的情况下)是1900年2月29日。 >
- Type "60" into a cell in Excel.
- Set the data type to a date format
- The date displayed (in my case at least) is February 29th, 1900.
然而,1900年2月29日从1900年开始就没有发生闰年(见维基百科)。
However, February 29th, 1900 never occurred since 1900 was not a leap year (see Wikipedia).
这是一个错误还是我缺少某些东西?
Is this a bug or am I missing something?
推荐答案
不,它不是Excel中的错误,是的,你错过了一些。
No, it is not a bug in Excel and yes you are missing something.
Excel实现了与Lotus 1-2-3匹配的日期,当时需要兼容性,因此被设计为有此错误。 Lotus 1-2-3有一个想法1900的错误是一个闰年。
Excel implemented the dates to match with Lotus 1-2-3 for which compatibility was required at the time so was designed to have this error. Lotus 1-2-3 had the bug of thinking 1900 was a leap year.
请参阅Microsoft的文档,为什么不修复它。
See Microsoft's documentation for the reasons why not to fix it.
这篇关于Excel中有关于日期的错误吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!