Convert text to hex2dec

  • Thread starter Thread starter mohsin
  • Start date Start date
M

mohsin

Hi

Appreciate for your help,


My value = 319,A03,B13,16, which is in text format. The numbers actually are
in hex value. What i need to do now is, convert the value from text to hex
then to decimal,

i'm using below expression for converting to hex, but is wrong..:)

CCDec: Val(Replace([tblclearcode]![CLEARCODE_ID],",",""))

Can someone help me please,

thank you
 
I came across this in another post a while back.

*****
The function you need is

Variant=CDEC("String")

Where String is the hex number prefixed with &H

Thus

MsgBox CDec("&HC1A")

would output 3098
*****

Daniel
 
HI daniel

Thanks,

But how i can present it in my query, instead of using msgbox,

br, mohsin
I came across this in another post a while back.

*****
The function you need is

Variant=CDEC("String")

Where String is the hex number prefixed with &H

Thus

MsgBox CDec("&HC1A")

would output 3098
*****

Daniel
[quoted text clipped - 11 lines]
thank you
 
Back
Top