GoogleFinance - Remove USD Symbol

google-sheets google-finance
Abela picture Abela · Mar 11, 2016 · Viewed 7.6k times · Source

Using google spreadsheets to display currency data, with USD as primary field for formula: =LEFT(V10*GoogleFinance("currency:USDEUR"),5)

I cannot figure out how to remove the the USD Symbol ($) from not show up for the additional currencies. It makes no sense to have the **$**xxx being displayed on non-USD data.

I have tried doing Format -> Numbers but none of those options resolve this issue.

enter image description here

Answer

Chris Hick picture Chris Hick · Mar 11, 2016

The number formats are not working since the LEFT function is converting the value to text. Does this formula work instead:

=SUBSTITUTE(LEFT(V10*GoogleFinance("currency:USDEUR"),5),"$","")

Related questions

How to use GOOGLEFINANCE(("CURRENCY:EURAUD")) function

This function: GOOGLEFINANCE(("CURRENCY:EURAUD")) works well in Google Sheets, I have searched the web up and down for some documentation regarding this function and how it is used, the closest I've got was this http://www.google.com/finance?…

Read More
How to make google spreadsheet refresh itself every 1 minute?

My google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to refresh manually now. How can I make the spreadsheet refresh itself every 1 minute? Thank you for your help.

Read More
How to get the price of a stock at a particular date from Google Finance?

I want to get the price of a stock at a particular date from Google Spreadsheet using Google Finance forumula. This is the formula I used; =GOOGLEFINANCE("GOOG","price",12/13/2013) It does not work. How can this be done?

Read More