Does anyone know if its possible to change the data type of a field from "Text" to "Number" by using a macro?

thx

Why? You can change it in a query using CDbl(), Val() or similar in a calculated field. Bear in mind that if your data is not capable of of being converted, you'll get errors.