title: GoogleFinance - Remove USD Symbol
body: <p>Using google spreadsheets to display currency data, with USD as primary field for formula: <code>=LEFT(V10*GoogleFinance("currency:USDEUR"),5)</code></p>
  
  <p>I cannot figure out how to <strong>remove</strong> the the USD Symbol <em>($)</em> from not show up for the additional currencies. It makes no sense to have the **$**xxx being displayed on non-USD data.</p>
  
  <p>I have tried doing <code>Format -&gt; Numbers</code> but none of those options resolve this issue.</p>
  
  <p><a href="https://i.stack.imgur.com/fBTqZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fBTqZ.png" alt="enter image description here"></a></p>