Faster way to apply DATEVALUE() to all cells in a column?

[Ragnaros]

Is there an easier/faster way to do this?

    Dim rng As Range

    For Each rng In ActiveSheet.ListObjects("UpdateStatusTable").DataBodyRange.Rows
        ActiveSheet.Cells(rng.Row, 3) = DateValue(ActiveSheet.Cells(rng.Row, 3))
    Next rng

There are over 10,000 rows. I want to convert all of the values in column 3 to dates, and for some reason using .NumberFormat isn't working so I'm trying to use DATEVALUE(). Each cell is in the format like 4/25/2014 as is.

[FDibbins]

Try this (no VBA)...

Hilight the range, select TextToColumns/Next/Next, check Date and select the format you want, click OK

[alansidman]

another alternative to this is to use Cdate function ---> https://www.udemy.com/blog/vba-cdate/

but I think the fastest way is to use Ford's solution.