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:
' EF_to_Number Macro
Selection.NumberFormat = "0.00"
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.