title: Changing number formatting in excel 2007
body: <p><img src="https://i.stack.imgur.com/5sAkS.png" alt="enter image description here"></p>
  
  <p>I have an Excel file that looks like this. How would I change the cell formatting so that it looks exactly like it does it the function bar.  Instead of <code>3E-07</code> --> <code>0.000003</code></p>
  
  <p>I don't want to change the decimal places because I only want it to have the number of decimal places it needs so there won't be extra zeroes at the end. 
  For example because the smallest numbers have 7 decimal places if I change the whole column to seven decimal places numbers like 6E-05 will have two extra zeroes (0.0000600) at the end. </p>
  
  <p>I'm trying to do this on macro because there are a lot of numbers to go through. I can set up the loop myself. </p>