title: Excel Text Format Number to round to millions
body: <p>Is there a way to imbed a number in a text string, while still rounding it to millions and showing an 'm'?</p>
  
  <p>If it was just formatting, I would use:</p>
  
  <pre><code>#.#,, 'm'
  </code></pre>
  
  <p>and in text I would use:</p>
  
  <pre><code>text(ref, "#.#,,")
  </code></pre>
  
  <p>but how can you combine the two? the below does not work</p>
  
  <pre><code>text(ref, "#.#,,m")
  </code></pre>