EXCEL 改變文本型日期類型

 

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.
工作中經(jīng)常有朋友將日期型數(shù)據(jù)輸入為文本型,導(dǎo)致影響與此數(shù)據(jù)相關(guān)的計算,下面我就把如何將文本型日期改變?yōu)槿掌谛偷姆椒ㄑ菔窘o大家：