title: Replace . to , in fetched currency amount of yahoo finance
body: <p>I am using <code>excel 2010</code>.
  I have the following vba function, which retrieves me currencies from yahoo finance. However, my problem is that I am using a German Version of Excel and the <code>.</code> is in this Version a <code>,</code>.</p>
  
  <p>Therefore the converted currencies look like that:</p>
  
  <p><img src="https://i.stack.imgur.com/T6YSV.jpg" alt="enter image description here"></p>
  
  <p>That is the function I am using:</p>
  
  <pre><code>Function MYCURRENCYEXCHANGER(SourceCur As String, DestCur As String) As Variant
      Dim url As String
      ' http://quote.yahoo.com/d/quotes.csv?s=XXXYYY=X&amp;f=l1  this is the link format where XXX is currency1 and YYY is currency2 '
      url = "http://quote.yahoo.com/d/quotes.csv?s=" &amp; SourceCur &amp; DestCur &amp; "=X&amp;f=l1"
      Dim myHTTP As New WinHttp.WinHttpRequest
      myHTTP.Open "GET", url, False
      myHTTP.send ""
      If myHTTP.StatusText &lt;&gt; "OK" Then GoTo ServerErrorHandler
      If Not (WorksheetFunction.IsNumber(myHTTP.responseText)) Then MYCURRENCYEXCHANGER = 0
      MYCURRENCYEXCHANGER = CDbl(myHTTP.responseText)
      Exit Function
  
  ServerErrorHandler:
      MsgBox "Error. Could not convert currency"
  
  End Function
  </code></pre>
  
  <p>Any recommendation how to convert the currency correctly so that the <code>.</code> is replaced by a <code>,</code> when fetched from yahoo finance?</p>
  
  <p>I apprecaite your replies!</p>