View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Convert numbers to HEX

Hi,

It's done with

mynum = Hex(mynum)

But in your partiular case we could do with seeing some examples of the
string that contains the decimal number.

Mike

"Madiya" wrote:

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