For the numeric entries you can do something like:

With yourrange
.NumberFormat = "General"
.Value = .Value
End With

this will convert the dates, but depending on your regional settings
and what was entered into the cell, they may not be accurate. It will
convert anything excel recognizes as a date to the number that
represents the date that excel thinks it is.

Cliff Edwards