CLng strange behaviour

Hi everybody,

I am noticing a strange (but maybe I am not using it in the right way ) behaviour of method CLng().
If I write:

Dim lngNum As Long
lngNum = CLng("400118E0")
MsgBox lngNum

the result is:
Cattura.PNG

wheres if I write

Dim lngNum As Long
lngNum = CLng("40011880")
MsgBox lngNum

the result is:
Cattura.PNG

Why is char 'E' not recognized and displayed on the message box?

I need to convert 32-bit address (to be used with .bin/.hex file) from string to hex value(i.e. input. "400118E0", output: 0x400118E0).

Thank you in advance,

Ziomocci

Hi Norie,

Because this is the format of memory address in binary file. I have used a message box as an example.
Memory locations in a binary file, considering entries of 16 bytes (for example), are 0x0, 0x10, 0x20...0x2000, 0x2010, 0x2020,...0x40000000, 0x40000010, 0x40000020,...0x40011800, 0x40011810, 0x40011820, 0x40011830, 0x40011840,...0x40011890, 0x400118A0, 0x400118B0, 0x400118C0, 0x400118D0 and so on.
For this reason I have to convert correclty the string.

Originally Posted by MrShorty

I don't think I understand. Converting the (decimal) number 400118E0 (scientific/exponential notation meaning 400118*10^0) to a long integer correctly interprets the number as 400118. Is the input supposed to be a hex number (hex 400118E0 = dec 1073813728)? If the inputs are supposed to be hexadecimal, I think you have to do something additional to tell VBA that those are hex numbers. If you don't, then VBA will assume they are decimal numbers. I never deal with hexadecimal numbers, so I am not sure exactly how that should be done. My one real encounter with hexadecimal suggested preceding hex numbers with &H

lngnum=CLng("&H400118E0")

or use some kind of Hex2Dec() function.

Hi MrShorty,

I need to take a String from a cell, eg. 400118E0, and convert it in Long 0x400118E0 so that I could use the value in other part of the program.

Originally Posted by Norie

E0 evaluates to 1 so 400118E0 evaluates to 40018.

Try running this, you'll see the results in the Immediate Window.

Dim s As String
Dim I As Long

    For I = 0 To 3
        s = "400118E" & I
        Debug.Print s & "=" & CLng(s)
    Next I

You have demonstrated that I am not using the method in the right way
therefore Norie, do you know a way (or more) to convert a String, eg. "400118E0", in Long value 0x400118E0, let me say, "char-by-char"?

If it was not enough clear, I am not used to work with VBA macros (I am an embedded-C programmer, so....)
For sure, thanks a lot for your fastest answers!!!

Problem solved with string concatentaion.
Thanks everybody!!!