title: powershell function for convert to number
body: <p>Im using powershell to open two excel workbook and copy data from one into another, the data I'm importing contains both text and numeric data.  After it's been imported, everything is treated as text. 
  i have two columns: A and B
  A has the following: 01234567 should get converted into 1234567
  B has the following: 01234567.05 should get converted into 1234567.05</p>
  
  <p>Of course I could manually do the "Convert to Number" function, but this import is done automatically so no manual action need to be performed. (another way to do it manually is to use the Text-to-column)</p>
  
  <p>This is not working, not even manually, if i try to make the conversion using the formating function, its not doing anything
  Worksheets("Sheet1").Range("A2:A5000").NumberFormat = "0000000"</p>