Hi to all,

I am trying to convert a number to a hex number using the Hex()
function in Excel but no luck !!!!
I am always getting the same error 13 datatype incompatilibity, pardon
my english, I'm french....
here is the code I use

' convertion en Hex
num = Cells(i, "T").Value
myhex = Hex(num) datatype error here
Cells(i, "U") = myhex


both of my variable are variant type and and the format of my data column
is in text, some number have letters in it
523535BA
08114572730
52204F23
08113848195
52210354


Can anyone tell me what I am doing wrong

Thanks

Alain