Format entire column

[clhare]

I need a macro in Excel that will format column A (no matter how many rows) with Custom number format of "00000". How would I do that?

[thomaspatton]

You could just select the Column Header (the A) which will select the entire row. Then, set the number format how you want in the options menu. This way, any number combination will show as "00000", while text will handle normally.

[Bob Phillips]

or in VBA



Activesheet.Columns(5).NumberFormat = "00000"

[clhare]

Thanks!

Another question.... is it possible to use a macro to apply the formatting for whatever cell or cells are selected?

[Bob Phillips]

Selection.NumberFormat = "00000"