PDA

View Full Version : Euro Sign wont work



snoopfan
11-26-2011, 11:56 AM
Dear All,

For some reason my excel stopped working the way it should.

For instance the € sign which is Char(0128), will show me
Ђ
I dont know what I touched while using it that it jumped to this.

I am entering the sign € in VBA editor and when it exports it to Excel cell it shows it as Ђ

Please anyone help.

Here I am attaching the file...

mdmackillop
11-26-2011, 02:02 PM
I'm not seeing that in your attachment. Check your font in the Euro cell.

snoopfan
11-26-2011, 02:07 PM
hmmm... weird

I still get that.

After some research I got to find out that € sign can be entered with CHAR(136).

It seems that I have problems with my excel. Has switched to Cyrillic codes. Any idea how can I switch back to Windows-1252
Latin-1?

mdmackillop
11-26-2011, 02:22 PM
Check out Regional/Language settings in Control Panel. If it's not there, I don't know where else to look.