WorksheetFunction.Bin2Dec Method
| Excel Developer Reference |
Converts a binary number to decimal.
Syntax
expression.Bin2Dec(Arg1)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation. |
Return Value
String
Remarks
If number is not a valid binary number, or if number contains more than 10 characters (10 bits), Bin2Dec generates an error value.
See Also