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?