HEX2BIN(number, places)

Returns the number converted from hexadecimal to binary.

numberThe hexadecimal number you want to convert.
placesThe number of characters to use.

* If "number" is not a valid hexadecimal number, then #NUM! is returned.
* If "number" < 0, then "places" is ignored and a 10-character binary number is returned.
* If "number" < 0, then it cannot be less than FFFFFFFE00, and if "number" is positive, it cannot be greater than 1FF.
* If "number" contains more than 10 characters (10 bits), then #NUM! is returned.
* If "number" contains 10 characters then the first number represents the sign of the number.
* If "places" is not an integer, it is truncated.
* If "places" < 0, then #NUM! is returned.
* If "places" is left blank, then the minimum number of characters necessary is used.
* If "places" is not numeric, then #VALUE! is returned.
* If "places" is less than the number of characters needed, then #NUM! is returned.
* The "places" is useful for padding the return value with leading 0s (zeros).
* Any negative numbers are represented using two's complement notation.
* You can use the HEX2DEC function to convert a number from hexadecimal to decimal.
* You can use the HEX2OCT function to convert a number from hexadecimal to octal.
* You can use the BIN2HEX function to convert a number from binary to hexadecimal.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

1=HEX2BIN("F", 8) = 00001111
2=HEX2BIN("F", 8.9) = 00001111
3=HEX2BIN("B7") = 10110111
4=HEX2BIN("FFFFFFFFFF") = 1111111111
5=HEX2BIN("some text") = #NUM!
8=HEX2BIN("FFFFFFFFFF", "some text") = #VALUE!

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top