GoogleFinance - Remove USD Symbol

Question

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.

score 6 · Accepted Answer · answered Mar 11 '16 at 21:56

6

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),"$","")

answered Mar 11 '16 at 21:56

Chris Hick

3,004
1
13
15

That worked Chris. Thanks a bunch. So, "left" converts to text. Good to know. And, "substitute" is basically a "str_replace" eh - very sweet! – Abela Mar 11 '16 at 22:15

score 2 · Answer 2 · answered Mar 11 '16 at 21:58

2

Highlight the cells you want to change. Go to Format --> Number --> More Formats --> Custom number format. Highlight the "$" and delete it (delete the quotes and dollar sign both). Click apply. I have attached before and after pictures.

answered Mar 11 '16 at 21:58

JenVander

325
2
11

Hey Jen, mine did not have "$" only $ and removing it did not do any good. – Abela Mar 11 '16 at 22:16
1

Interesting, I haven't seen that before. Glad Chris' suggestion worked out though :) – JenVander Mar 11 '16 at 23:30

GoogleFinance - Remove USD Symbol

2 Answers2