某些日期确认为日期,某些日期未确认。为什么? [英] Some dates recognized as dates, some dates not recognized. Why?
问题描述
以下是日期列表:
04-22-11
12-19-11
11 -04-11
12-08-11
09-27-11
09-27-11
04-01 -11
当您在Excel中复制此列表时,其中一些将以下列方式识别为日期,其他不被识别:
04-22-11
12-19-11
11-04-11(date)
12-08-11 (日期)
09-27-11
09-27-11
04-01-11(date)
有人知道为什么吗?如何强制Excel将所有列表项目识别为日期?
非常感谢!
这不是很难...
查看此论坛帖子:
< a href =http://www.pcreview.co.uk/forums/excel-not-recognizing-dates-dates-t3139469.html> http://www.pcreview.co.uk/forums/excel-not -recognizing-dates-dates-t3139469.html
简单的步骤:
- 只选择日期列。
- 点击数据>文本到列
- 点击下一步
- 单击下一步
- 在向导的步骤3中,在Col数据格式下选择Date,然后
从droplist选择DMY。 - 点击完成
Here is a list of dates:
04-22-11
12-19-11
11-04-11
12-08-11
09-27-11
09-27-11
04-01-11
When you copy this list in Excel, some of them are recognized as dates, others not, in the following manner:
04-22-11
12-19-11
11-04-11 (date)
12-08-11 (date)
09-27-11
09-27-11
04-01-11 (date)
Does anyone know why? And how to force Excel to recognize all list items as dates?
Many thanks!
It's not that hard...
Check out this forum post:
http://www.pcreview.co.uk/forums/excel-not-recognizing-dates-dates-t3139469.html
The steps in short:
- Select only the column of "dates"
- Click Data > Text to Columns
- Click Next
- Click Next
- In step 3 of the wizard, check "Date" under Col data format, then choose: "DMY" from the droplist.
- Click Finish
这篇关于某些日期确认为日期,某些日期未确认。为什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!