On Sep 20, 3:07*pm, "Peter T" <peter_t@discussions wrote:
TheHexfunction as suggested is probably OK for your needs. But to be on
the safe side post an example of aHexcode and the equivalent number, just
in case the bit and or byte order is reversed.

Regards,
Peter T

"Madiya" wrote in message

...



Hi,
I am using excel to open a web page with a url.
All are fine except building a url where I need to convert contents of
cell toHEX.
All cell contents will be 10 digit numbers.
I have a url which will be appended with this HAX at the end.

Is there any way to convert this 10 digit numbers toHEXby VBA?

Regards,
Madiya- Hide quoted text -

- Show quoted text -

Yes, You are right.
I am getting error in VBA function Hex(1234567890) .
Error is "Runtime error '6' ", Over Flow.

Here is an example of input and output reqd.
input 9320545500
output EDD7EA6A0CDC5CA7212187EB854408ADF73E7F7BA2FF95BA

input 9320545566
output 695B91538F72D3B2F0BED374FA4E02A9634A1C4CE9292966

Pl help.

Regards,
Madiya