Convertion to Hex

A

Alain

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
 
J

JohnI in Brisbane

Alain,

I was looking at your code /data & wondering if you want to convert to Hex
or Decimal.
Your data is already in Hex, so i thought maybe you want to convert to
decimal.
The following macro seems to work.

===================
Dim num As String
Dim myhex As Long

num = Cells(5, "T").Value
myhex = CDec("&H" & num)
Cells(5, "U") = myhex
=======================

regards,

JohnI
 
A

Alain

Thanks John
I just look again at my data and some of it are in Hex so I will
need to make a validator program of some sort.....
what I really need to do is to convert into an Hex and still no luck

Thanks
Alain
 
J

JohnI in Brisbane

Alain,

Your original program works perfectly for me (converting decimal to
Hexadecimal), no problems??!!

i.e. given valid data.

Perhaps you can use "On Error GoTo" to trap invalid data.

regards,

JohnI
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top