Create a macro to format a column

Greetings,

I am not a programmer but I know how to create basic macros that would perform simple repeated tasks in a fixed range within a sheet.

Right now I'm encountering a task that would require a tiny bit of programming versus a simple recording of a macro. I happen to find this site . . . I was wondering if someone could help. I am greatful for those who could take their time to resolve this. Many thanks in advance.

Routinely I recieve Excel workbooks from new vendors. Each vendor would have their fields(columns) and formats arranged differently. I'm wondering if some could show me how to create a macro that would format a column that I select.

For example, when I open up a workbook, if I select column C (a date field) and run the macro, the macro would format column C into mm/dd/yy. If I select Column F and run the macro, the macro would format coumn F into mm/dd/yy.

Again - many thanks.