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