You don’t even need to write a macro. Excel’s Import Text Wizard will allow you to assign data type to each column at the time of import.