Spread.NET 18 Formula Reference
Formula Functions / Functions M to Q / OCT2HEX
In This Topic
    OCT2HEX
    In This Topic

    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)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    OCT2BIN | OCT2DEC | HEX2OCT | DEC2OCT | Engineering Functions