long dates not recognized as dates

[rjmdc]

ji
my date column has dates as long Dtaes december 24, 2024
the cells list cell types as date however i cannot sort or filetr as they eem to be text lso verified by formula =ISNUMBER(DATEVALUE(A2))
most say text

what can I do to fix this?
thanks

 

[rjmdc]

some are dates some are not
how do i convert all into dates
not in post 18

 

[Cubist]

I meant #16.
Please study the post carefully before you reply that they don't work. Look at 16 again, all values in C are dates - that is validated by the ISNUMBER in column H.

 

[rjmdc]

thank you
now it works

 

[kvsrinivasamurthy]

Is it possible to upload file with only date column and other column data erased.