character to integer conversion
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 |
character to integer conversion
Hi Lithium81,
MsgBox Asc("A") --- Regards, Norman "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 |
character to integer conversion
A1="A"
in B1 put =Code(A1) or =Code("A") "lithium81" wrote: 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 |
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 |
character to integer conversion
Thanks folks! That helps a lot!! -- lithium81 ------------------------------------------------------------------------ lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461 View this thread: http://www.excelforum.com/showthread...hreadid=520458 |
All times are GMT +1. The time now is 07:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com