|
<< Click to Display Table of Contents >> BIN2DEC (binary number to decimal number) |
Syntax:
BIN2DEC(Number)
Description:
Converts the given binary number (base 2) to a decimal number (base 10).
Number is the number to be converted.
Negative numbers have to be transformed to two's complement notation (see last example).
Number must not contain more than 32 places, so the permissible value range is:
-(2^31) ≤ Number ≤ (2^31)-1
Example:
BIN2DEC("101010") returns 42
BIN2DEC("00101010") returns 42 as well
BIN2DEC("11111111111111111111111111010110") returns -42
See also: