btkrausen
asked on
Excel Macro to Change Column Format to Number?
I'm having a terrible time with what I think should be a very simple macro. I need to select columns E and F and change their format to Number.
Here is what I have currently:
I've also tried selecting just one column or the other and the same problem occurs. What am I missing?
For what it's worth, I'm using Excel 2013.
Thanks!
Here is what I have currently:
Sub EF_to_Number()
'
' EF_to_Number Macro
'
'
Range("E:E,F:F").Select
Selection.NumberFormat = "0.00"
End Sub
When you run this macro it changes ALL columns to number format - not just E and F.I've also tried selecting just one column or the other and the same problem occurs. What am I missing?
For what it's worth, I'm using Excel 2013.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I didnt type fast enough.. ;)
ASKER
That worked perfectly! Thanks.
Worksheets("Sheet1").Colum
Worksheets("Sheet1").Colum
That would do column e and f