Excel Text Format Number to round to millions
<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>