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

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/as...331361033.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?

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.






"RSA72" wrote in message
...
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/as...331361033.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?

"RSA72" wrote:

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/as...331361033.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?

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


"RSA72" wrote:

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/as...331361033.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?

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

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


"RSA72" wrote:


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/as...331361033.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?