This topic has been archived. It cannot be replied.
-
工作学习 / English / help: Excel file, how to convert text type into date or number type?Hi!
One of the columns in a excel file contains following text type information:
Nov 15 05, that means 2005/09/15. the excel file has 2000 rows. How can I convert this column into date type?
Thanks a lot.
-wangliqdcn(await);
2005-12-6
{213}
(#2647690@0)
-
select all the cells that u want to change, then right click /format cells/ number/ choose date in the category, then pick the one u want.
-q_q(麦得);
2005-12-7
(#2648699@0)