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

[Ragnaros]

Is there an easier/faster way to do this?

Please Login or Register  to view this content.

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.