title: Euro symbol not showing (VBA)
body: <p>I'm trying to write an If statement that checks an input (a currency) and then assigns the correct symbol to the dollar amount. My code is below, every currency works except for the euro, which only works if the dollar amount is letters, and not numbers. Am I missing something obvious?</p>
  
  <pre><code>If Note_Currency = "" Then
      Note_Denomination = "$" + Note_Denomination
  ElseIf Note_Currency = "EUR" Then
      Note_Denomination = "€" + Note_Denomination
  ElseIf Note_Currency = "JPY" Then
      Note_Denomination = "¥" + Note_Denomination
  ElseIf Note_Currency = "GBP" Then
      Note_Denomination = "£" + Note_Denomination
  Else
      Note_Denomination = "$" + Note_Denomination
  End If
  </code></pre>