WorksheetFunction.Bin2Dec Method

  • Article

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.Object

    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

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.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace