[tssva]

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.

[LikesPwsh]

Same for Power Query and Text to Columns.