? chr(&H39)
9

--
Regards,
Tom Ogilvy


"ajocius" wrote:


Group,
Is there a function in VBA that will convert hex into ascii.
Example assume I have 0x39 and I want it to convert it to ascii, or 9.
Same goes for the alpha characters as well A thru Z both lower case and
upper case.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=544141