I had dates in 2 formats in 1 column both 01/10/2016 and 1 October 2016. In order to correct the error and allow sorting of the columns I created another column and formulated =DATEVALUE(A2).
This worked producing a number tat I could format as Date 01/01/2016 but the data remains linked to the previous cell. I want to copy this and paste the answer (not the formula) into a new column. In other words removing the link and just adding the actual data. Can I do that?