DEC2HEX
Converts decimal number to hexadecimal.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Text
Examples
=DEC2HEX(100, 4) Result 0064
Syntax
DEC2HEX(number, [places]) number- number required
places- number optional defaults to
1
Errors
#NUM!=DEC2HEX(64, 1)