Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / BIN2HEX
In This Topic
    In This Topic

    This function converts a binary number to a hexadecimal number.




    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


    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.



    Version Available

    This function is available in product version 2.0 or later.

    See Also

    BIN2DEC | BIN2OCT | DEC2HEX | OCT2HEX | Engineering Functions