BIN2DEC

Description Converts a binary number (base 2) to a decimal number (base 10).

Syntax BIN2DEC ( binary_number)

Argument Description

binary_number Any number expressed in the binary number system (represented by the digits 1 or 0).Data may be entered in text or numerical form. A maximum of 9 value bits (or digits) is allowed in representing positive values. To represent negative values, enter exactly 10 digits--the first digit must be a 1. Positive values may be zero-padded on the left up to a maximum of 10 digits.

Argument	Description
binary_number	Any number expressed in the binary number system (represented by the digits 1 or 0).Data may be entered in text or numerical form. A maximum of 9 value bits (or digits) is allowed in representing positive values. To represent negative values, enter exactly 10 digits--the first digit must be a 1. Positive values may be zero-padded on the left up to a maximum of 10 digits.

Remarks Note that the result is a numeric value.

Examples This function returns 1:

BIN2DEC(0000000001)

This function returns 128:

BIN2DEC(10000000)