title: Cell Text to Number (based on Cell Text Value)
body: <p>I have the following table:</p>
  
  <pre><code>2.0 M
  1.9 M   
  1455.0 K    
  1386.9 K    
  </code></pre>
  
  <p>Is there a way that I can convert that table into Numerical values based on the Letter at the end of the table such that the following is output:</p>
  
  <pre><code>2.0 M   2,000,000
      1.9 M   1,900,000
      1455.0 K    1,455,000
      1386.9 K    1,386,900
  </code></pre>
  
  <p>so: Remove the letter and multiply by either 1,000,000 or 1,000</p>
  
  <p>Thanks,</p>