How to change the data type of a Sharepoint Column from number to datetime?

Question

I have a Sharepoint 2010 list which has a column of type "Number" how do I change the data type to DateTime.

Answer 1

Number and Datetime fields are quite different and directly switching from number to date via web interface is not allowed. However, you can first change number->text and then text->date. (Of course, you may lose your data during conversation)

Answer 2

In the ribbon..follow the path as shown below

ListTools-->List---->List Settings-->Columns--->Click on "Your column name"-->Selct date time in "The type of information in this column is" radio button-->Additionally (Date time format under description if needed)--->Click Ok