View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default character to integer conversion

lithium81,
If on a worksheet, check the CODE and CHAR functions in Excel Help
If in VBA, then it's ASC and CHR in VBA help.

NickHK

"lithium81" wrote in
message ...

Is there any way to convert a charatcer into its decimal value in excel
VBA?

E.g. to compare "A" to the number 65 which is its decimal equivalent?

Thank you!


--
lithium81
------------------------------------------------------------------------
lithium81's Profile:

http://www.excelforum.com/member.php...o&userid=29461
View this thread: http://www.excelforum.com/showthread...hreadid=520458