EXCEL 改变文本型日期类型
中国教程网zhangditony翻译，转载请保留此信息 .
To change the formatting from Text to Date, use Text to Columns technique:(text to columns--中文版中的“分列")
1. Select the column formatted as text.
2. From the Data menu, select Text to Columns.
3. In Step 1 of 3, select the Fixed width option button.
4. Skip Step 2 of 3.
5. In Step 3 of 3, check Date option button in Column data format, and click Finish.
工作中经常有朋友将日期型数据输入为文本型,导致影响与此数据相关的计算,下面我就把如何将文本型日期改变为日期型的方法演示给大家：
1. Select the column formatted as text.
2. From the Data menu, select Text to Columns.
3. In Step 1 of 3, select the Fixed width option button.
4. Skip Step 2 of 3.
5. In Step 3 of 3, check Date option button in Column data format, and click Finish.
工作中经常有朋友将日期型数据输入为文本型,导致影响与此数据相关的计算,下面我就把如何将文本型日期改变为日期型的方法演示给大家：
![20070713_a9299763c6c9faf776dfvne5reumerve[1].gif](https://atts.w3cschool.cn/attachments/image/20151103/1446546495798451.gif "1446546495798451.gif")