Navigation:  Formula Reference > Spreadsheet Formula Functions >

BIN2HEX

Previous pageReturn to chapter overviewNext page

 

This function converts a binary number to a hexadecimal number.

Syntax

BIN2HEX(number,places)

Arguments

This function has these arguments:

Argument

Description

number

Binary numeric value to convert

places

[Optional] Number of characters to return; if not an integer, the number is truncated

Remarks

An error value is returned if the number contains more than 10 digits or is invalid, or if the value of places is non-numeric or negative. If places is omitted, the calculation uses the minimum number of characters necessary. This argument is useful for adding leading zeros to the result.

Data Types

Accepts numeric data. Returns numeric data in hexadecimal format.

Examples

BIN2HEX(1110)

 

See Also

BIN2DEC

BIN2OCT

DEC2HEX

OCT2HEX