sharif.s.786 wrote:

Sorry for being a dummy but how do we use this in excel. I am desperate
to convert large values to hex.

Rick posted VBA code. Copy the code to a module in the VBA editor, then in
your spreadsheet do this:

=BigDec2Hex(1234567890)

....replacing "1234567890" with your number.

Also is there a way to convert float value to hex (ieee 754?)

https://www.google.com/#q=convert+fl...lue+to+hex+vba

--
If a thing is wrong, it is wrong -- and vox populi can't change it.