From: Raj on 16 Sep 2009 23:53 How to convert hex data to ASCII and the vice versa? Ex: if I give ABC I will get 414243 Thank you Regards Raj From: Nobody on 17 Sep 2009 00:33 Debug.Print Val("&H" & "ABC") Debug.Print Hex(414243) From: Eduardo on 17 Sep 2009 00:55 Raj escribiÃ³: > How to convert hex data to ASCII and the vice versa? > Ex: if I give ABC I will get 414243 How 414243 relates to ABC? It is not a conversion to ASCII nor to decimal (Dec). ASCII and decimal are different things. ABC in ASCII is 656667 (OK, it's just two digits of the ASCII codes) Debug.Print CStr(Asc("A")) & CStr(Asc("B")) & CStr(Asc("C")) ABC in decimal is 2748 Debug.Print &HABC From: Raj on 17 Sep 2009 00:56 I am sorry it is workin out! "Nobody" wrote: > Debug.Print Val("&H" & "ABC") > Debug.Print Hex(414243) > > > From: James Hahn on 17 Sep 2009 03:06 Hex(Asc("A")) & Hex(Asc("B")) & Hex(Asc("C")) "Eduardo" wrote in message news:h8sfh6\$sd3\$1(a)aioe.org...> Raj escribiÃ³: > >> How to convert hex data to ASCII and the vice versa? > >> Ex: if I give ABC I will get 414243 > > How 414243 relates to ABC? > > It is not a conversion to ASCII nor to decimal (Dec). > > ASCII and decimal are different things. > > ABC in ASCII is 656667 (OK, it's just two digits of the ASCII codes) > Debug.Print CStr(Asc("A")) & CStr(Asc("B")) & CStr(Asc("C")) > > ABC in decimal is 2748 > Debug.Print &HABC  |  Next  |  Last