Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
"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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel file in ASCII? | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |