title: Round and concatenate an abbreviation in excel
body: <p>I am trying to format the market cap of companies in excel to look like google- ie, </p>
  
  <pre><code>15.46B 
  456.78M
  </code></pre>
  
  <p>In a google spreadsheet I call the function =GoogleFinance(A2, "MarketCap") and receive the data. For instance ACMP with a market cap of 7,916,327,249.00. </p>
  
  <p>Then I conditionally divide  by =IF(E2>1000000000,E2/1000000000,E2/1000000) to get the number in a decimal form.  If marketcap is over a billion then it divides by a bil.  If it is under then i divide by a mil. </p>
  
  <p>Now it is 7.916327249.  I have that to 7.92.  Lastly I try to concateinate with
  =IF(E2>1000000000,CONCAT(F2," B"),CONCAT(F2," M")) but it undoes the rounding and  I get 
  7.916327249B.  Any easy way around this? thanks.</p>