WorksheetFunction.Bin2Dec Method
Converts a binary number to decimal.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Bin2Dec ( _
Arg1 As Object _
) As String
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim returnValue As String
returnValue = instance.Bin2Dec(Arg1)
string Bin2Dec(
Object Arg1
)
Parameters
Arg1
Type: System.ObjectThe 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
Type: System.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.