title: Macro to convert every 9th column into numbers in excel
body: <p>For some reason, even when I select a column, right click, and format the cells to be numbers, I still get an alert with a green corner in the cell that says that it's a number stored as text. I then highlight the range, click the exclamation point in the yellow box, and convert the range to numbers.</p>
  
  <p>The problem is that I have to do this for hundreds of ranges. </p>
  
  <p>How can I make a macro to highlight a range (e.g. XP2:XP2700) in every 9th column, and convert the entire range to numbers?</p>