View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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