Calc BIN2HEX function

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the BIN2HEX function.

Description

Converts a binary number to hexadecimal.

Syntax

BIN2HEX(number, [places])

• number - Required. The binary number you want to convert to hexadecimal. The number can be a text string or a number.
• [places] - Optional. The number of characters to use. If the result has fewer characters than places, BIN2HEX adds leading zeros to the result until it reaches the specified length.

Remarks

• If the number is not a valid binary number, BIN2HEX returns the #NUM! error value.
• If the number is larger than 511, BIN2HEX returns the #NUM! error value.
• If the number is less than -512, BIN2HEX returns the #NUM! error value.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc BIN2DEC function
• Calc BIN2OCT function
• Calc CONVERT function
• Calc DEC2BIN function
• Calc DEC2HEX function