ASCII extended set is different in Excel, than MS's Website?

[Guest]

When I use the =Char(189) formula in Excel, it returns 1/2. I go on
Microsoft's website:
http://office.microsoft.com/en-us/assistance/HA011331361033.aspx
and the code for 1/2 is 171. Can anyone tell me why this is? Can I use a
assign a different extended character set to be used in Excel?

 

[Alan]

Its apparently wrong. ASCII 189 and therefore =CHAR(189) is 1/2 ,ASCII 171
and =CHAR(171) is <<
To see all the combinations try
=CHAR(ROW())
in A1 and drag down to A255
Change the fonts to see what occurs,
Regards,
Alan.

 

[Guest]

When I use the =Char(189) formula in Excel, it returns 1/2. I go on
Microsoft's website:
http://office.microsoft.com/en-us/assistance/HA011331361033.aspx
and the code for 1/2 is 171. Can anyone tell me why this is? Can I use a
assign a different extended character set to be used in Excel?

 

[Guest]

Did you ever get an answer to this problem? I have the same exact problem

 

[Rowan]

If you search for "Character Set (128 – 255)" in the Excel VBA help
files it shows the character set with 189 = 1/2 and 171 = <<.

Regards
Rowan