Navigation:  Formula Reference > Spreadsheet Formula Functions >

DEC2HEX

Previous pageReturn to chapter overviewNext page

 

This function converts a decimal number to a hexadecimal number.

Syntax

DEC2HEX(number,places)

Arguments

This function has these arguments:

Argument

Description

number

Decimal numeric value to convert in the range of -549,755,813,888 to 549,755,813,887

places

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

If places argument is omitted, the calculation uses the minimum number of characters necessary. This argument is useful for adding leading zeros to the result.

Remarks

An error value is returned if the number is non-numeric or outside the range, or if the places value is non-numeric, negative, or too small.

Data Types

Accepts numeric data. Returns numeric data.

Examples

DEC2HEX(103,4)

 

See Also

BIN2HEX

DEC2BIN

DEC2OCT

OCT2HEX