How to convert DEC into HEX in Excel?

Question

I need to do a list of numbers since 000000 to FFFFFF in Excel.

How can I convert a column of decimal numbers in HEX numbers in Excel?

Is there any function to do it?

Answer 1

Select Tools | Add-ins and ensure that "Analysis ToolPak" is selected.  This will give you access to new fundtions including HEX2DEC and DEC2HEX

e.g. =DEC2HEX(12) would return C

=DEC2HEX(9999) would return 270F