Navigation:  Formula Reference > Spreadsheet Formula Functions >

OCT2HEX

Previous pageReturn to chapter overviewNext page

 

This function converts an octal number to a hexadecimal number.

Syntax

OCT2HEX(number,places)

Arguments

This function has these arguments:

Argument

Description

number

Octal numeric value to convert, must be 10 characters or less

places

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

Remarks

An error value is returned if the number is invalid or if 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.

Examples

OCT2HEX(7777)

 

See Also

DEC2OCT

HEX2OCT

OCT2BIN

OCT2DEC