Could I change the table data type automatically using macro . for example I convert text data to number data by using (Mid) f682515 => 682515 but the data type still text.

Please help .
thank you

Make a second (dummy) column, that is number
Now do an update query using the mid to fill the new column
Then rename the dummy and remove the original...

Seasons greetings from amsterdam