Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASCII CODE of a character...
Hi,
I use =code function in excel to see the ascii code for a character. But when i try to use the "code" function, it crashes. Could you please advise the code to see the ascii code? Thanks and regards, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASCII CODE of a character...
In VBA, use the Asc function.
Debug.Print Asc("A"), Hex(Asc("A")) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting LLC www.cpearson.com (email on the web site) "SupperDuck" wrote in message ... Hi, I use =code function in excel to see the ascii code for a character. But when i try to use the "code" function, it crashes. Could you please advise the code to see the ascii code? Thanks and regards, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASCII CODE of a character...
If you just want to see what the ASCII character is for a keyboard character,
you can type <ascii character set in VBA help and it will bring up a menu for 0-127 and 128- End. "SupperDuck" wrote: Hi, I use =code function in excel to see the ascii code for a character. But when i try to use the "code" function, it crashes. Could you please advise the code to see the ascii code? Thanks and regards, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ASCII CODE of a character...
hey
well im not sure i know how to do it through code, but maybe this'll help: Go to Insert - Symbol.. scroll through them and click on the one you're looking for. at the bottom of this window, it tells the character code. to the right of it, theres a drop down menu thingy that allows you to switch between viewing the ASCII(hex), ASCII(decimal), and UNICODE(hex) code for a character. i'm not sure if this helped you "SupperDuck" wrote: Hi, I use =code function in excel to see the ascii code for a character. But when i try to use the "code" function, it crashes. Could you please advise the code to see the ascii code? Thanks and regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plus or minus character ...Its ASCII value | New Users to Excel | |||
ascii character in custom format | Excel Discussion (Misc queries) | |||
How to: Convert character to ASCII code | Excel Discussion (Misc queries) | |||
Cannot insert extended ascii character | Excel Discussion (Misc queries) | |||
Delete ascii character 127 | Excel Programming |