BIN2HEX

LEGACY.BIN2HEX

LEGACY.BIN2HEX(value, places = 0)

Converts a binary-formatted value to hexadecimal format. LEGACY.BIN2HEX is compatible with the BIN2HEX formula function used in many spreadsheet programs, and value is limited to 10 characters. The first character is the sign bit.

The optional places parameter defines the number of characters to use, padding the return value with loading zeroes if it's shorter.