Marco to convert numbers stored as text to numbers and dates stored as text to numbers

Hi

I need assistance in writing a macro to change numbers which are stored in an excel sheet as text to numbers and converting dates stored as text to numbers :

I have attached a sample list of 18 rows, in reality the number of rows of data changes month to month so the marco would need to be able to work over different number of rows of data.

column A the contract numbers are stored as text, i can convert them to numbers using the =value() formula can this be done in a marco.
column B the start dates are stored as text in the following format 2012-07-01 00:00:00, i can convert them to dates using the following formula = datevalue(), can this be done in a marco?

column C and E is the same as A

column D is the same as B

thanks for your helpexample.xlsx

thank you for this very much! however I have noticed a problem, if there is a blank cell then the marco stops and an error shows with Run Time error 12 Type mismatch, how can I get the marco to run around the blank value

thanks a lot very good help!

Trebor76 I found this thread in search to the very thing you posted. I was able to use the code you provided but ran into a problem. I have values in the "A" column that are numbers and letters for example (0B, LL1, LL2, 6M) Using your code the letters disappear if they are after numbers for example (0B turns into 0) and (6M turns into 6) is there any way to adjust for this?

Thanks for your time and help!!