View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default Convert numbers to HEX

Use the HEX function in VBA

e.g. myHex = Hex(1234567890)



--

Regards,
Nigel




"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 to HEX.
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 to HEX by VBA?

Regards,
Madiya