Forum Discussion
Dates not Sorting
Hi I have attached an image, I am using the sort filter to put the dates in order and as you can see at the top three of the rows are not filtering correctly and just staying at the top, I wond...
Hi Lorenzo,
Just to clarify so I put that formula in for me it would be =datevalue(c2) would go into the cell d2, then do i copy that formula into every cell in the new column?
and then do I have to go down every cell to do the copy and then paste special values, and then delete the old column and apply the new sorting?
Just to clarify so I put that formula in for me it would be =datevalue(c2) would go into the cell d2, then do i copy that formula into every cell in the new column?
and then do I have to go down every cell to do the copy and then paste special values, and then delete the old column and apply the new sorting?
