Create a macro to format a column Solved/Closed

Question

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.

Configuration: Windows XP / Internet Explorer 7.0

rizvisa1 · Answer

If only thing that you want to do is covert the text of columns into date, then you can use the Text to column option available under Data

Bren · Answer

Place this on a module on VBA Editor

Sub format()
Selection.NumberFormat = "mm-dd-yy"

End Sub

When you want to run the macro, select the column you want to format and then run the macro

Create a macro to format a column

2 responses

Similar discussions

Subscribe To Our Newsletter!