excel - Euro symbol not showing (VBA) -


i'm trying write if statement checks input (a currency) , assigns correct symbol dollar amount. code below, every currency works except euro, works if dollar amount letters, , not numbers. missing obvious?

if note_currency = ""     note_denomination = "$" + note_denomination elseif note_currency = "eur"     note_denomination = "€" + note_denomination elseif note_currency = "jpy"     note_denomination = "¥" + note_denomination elseif note_currency = "gbp"     note_denomination = "£" + note_denomination else     note_denomination = "$" + note_denomination end if 

okay figured out - kind of. tried sub in excel , same thing happens me. using symbol , chr(128) shows blank cell.

what found worked if know range have these numbers, change cell's format type text (@):

range("a1:a100").numberformat = "@"

then, when run code, euro symbol shows if use note_denomination = chr(128) & note_denomination.

so, looks reason wasn't code, cell formatting.


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -