Base conversion functions

Name: BIN2DEC
Syntax: BIN2DEC(<binary_string>)
Description: Convert binary to decimal.
Version: 3.4
Example: BIN2DEC("1011")

Name: BIN2HEX
Syntax: BIN2HEX(<binary_string>)
Description: Convert binary to hexadecimal.
Version: 3.4
Example: BIN2HEX("10101011")

Name: BIN2OCT
Syntax: BIN2OCT(<binary_string>)
Description: Convert binary to octal.
Version: 3.4
Example: BIN2OCT("101110101")

Name: DEC2BIN
Syntax: DEC2BIN(<number>)
Description: Convert decimal to binary
Version: 3.4
Example: DEC2BIN(53)

Name: DEC2HEX
Syntax: DEC2HEX(<number>)
Description: Convert decimal to hexadecimal.
Version: 3.4
Example: DEC2HEX(53)

Name: DEC2OCT
Syntax: DEC2OCT(<number>)
Description: Convert decimal to octal.
Version: 3.4
Example: DEC2OCT(35)

Name: HEX2BIN
Syntax: HEX2BIN(<hex_string>)
Description: Convert hexadecimal to binary.
Version: 3.4
Example: HEX2BIN(<hex_string>)

Name: HEX2DEC
Syntax: HEX2DEC(<hex_string>)
Description: Convert hexadecimal to decimal.
Version: 3.4
Example: HEX2DEC("AB")

Name: HEX2OCT
Syntax: HEX2OCT(<hex_string>)
Description: Convert hexadecimal to octal.
Version: 3.4
Example: HEX2OCT("AB")

Name: OCT2BIN
Syntax: OCT2BIN(<octal_string>)
Description: Convert octal to binary.
Version: 3.4
Example: OCT2BIN(72)

Name: OCT2DEC
Syntax: OCT2DEC(<octal_string>)
Description: Convert octal to decimal.
Version: 3.4
Example: OCT2DEC(72)

Name: OCT2HEX
Syntax: OCT2HEX(<octal_string>)
Description: Convert octal to hexadecimal.
Version: 3.4
Example: OCT2HEX(72)

Return to categories