Displaying Hexadecimal numbers in Excel

Not so well documented, but there is a way to display hexadecimal numbers in Excel. Use the following formula to convert a number into hexadecimal format:

="0x"&DEZINHEX(A1)