Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convertion to Hex
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convertion to Hex
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 "Alain" wrote in message .. . 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convertion to Hex
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 "JohnI in Brisbane" a écrit dans le message de ... 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 "Alain" wrote in message .. . 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convertion to Hex
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 "Alain" wrote in message .. . 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 "JohnI in Brisbane" a écrit dans le message de ... 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 "Alain" wrote in message .. . 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do a kg to stone convertion in excel | Excel Discussion (Misc queries) | |||
Date convertion | Excel Discussion (Misc queries) | |||
Convertion | New Users to Excel | |||
.wb3 file convertion | Excel Worksheet Functions | |||
CONVERTION $750 TO WORDS | New Users to Excel |