Number Conversion
ROMAN
Converts a given number into a Roman numeral. Syntax ROMAN(number; [mode]) number: The number you want to convert to a Roman numeral. It can range from 1 to 3999, inclusive. Eg., 6 mode: Indicates the degree of simplification. It can range from 0 ...
OCT2HEX
Converts a given octal number to hexadecimal. Syntax OCT2HEX(octal_number; [num_of_digits]) octal_number: The octal number you want to convert into hexadecimal. It can contain a maximum of 10 characters, between 0-7. Eg., 77 num_of_digits: The ...
OCT2DEC
Converts a given octal number to decimal. Syntax OCT2DEC(octal_number) octal_number: The octal number you want to convert into decimal. It can contain a maximum of 10 characters, between 0-7. Eg., 77 Examples Formula Result =OCT2DEC(77) 63 ...
OCT2BIN
Converts a given octal number to binary. Syntax OCT2BIN(octal_number; [num_of_digits]) octal_number: The octal number you want to convert into binary. It can contain a maximum of 10 characters, between 0-7. Eg., 77 num_of_digits: The number of ...
HEX2OCT
Converts a given hexadecimal number to octal. Syntax HEX2OCT(hexadecimal_number; [num_of_digits]) hexadecimal_number: The hexadecimal number you want to convert into octal. It must contain a maximum of 10 characters, between 0-9 and A-F. Eg., ...
HEX2DEC
Converts a given hexadecimal number into decimal. Syntax HEX2DEC(hexadecimal_number) hexadecimal_number: The number you want to convert into decimal. It must contain a maximum of 10 characters, between 0-9 and A-F. Eg., "FF" Remarks It is ...
HEX2BIN
Converts a given hexadecimal number into binary. Syntax HEX2BIN(hexadecimal_number; [num_of_digits]) hexadecimal_number: The hexadecimal number you want to convert into binary. It can contain a maximum of 10 characters, between 0-9 and A-F. Eg., ...
DECIMAL
Returns a decimal number given a text representation and its base. Syntax DECIMAL(number; radix) number: Text representing a number. Eg., 1 radix: The base of the number. It must be an integer between 2 and 36. Eg., 2 Type Range Radix Binary ...
DEC2OCT
Converts a decimal number to octal. Syntax DEC2OCT(decimal_number; digits) decimal_number: The decimal number you want to convert into octal. It must be between -2 29 and 2 29 -1 inclusive. Eg., 478.75 num_of_digits: The number of digits to return. ...
DEC2HEX
Converts a decimal number to hexadecimal. Syntax DEC2HEX(decimal_number; [num_of_digits]) decimal_number: The decimal number you want to convert into hexadecimal. It must be between -2 39 and 2 39 -1 inclusive. Eg., 478.75 num_of_digits: The ...
DEC2BIN
Converts a decimal number to binary. Syntax DEC2BIN(decimal_number; [num_of_digits]) decimal_number: The decimal number to be converted to binary. It must be between -512 and 511. Eg., 478.75 num_of_digits: The number of digits to return. Eg., 12 ...
BIN2OCT
Converts a binary number to octal. Syntax BIN2OCT(binary_number; [num_of_digits]) binary_number: The number you want to convert into octal. It can have a maximum of 10 digits (10 bits), with no digits other than 0 and 1. Eg., 1111 num_of_digits: ...
BIN2HEX
Converts a binary number to hexadecimal. Syntax BIN2HEX(binary_number; [num_of_digits]) binary_number: The number you want to convert into hexadecimal. It can have a maximum of 10 digits (10 bits), with no digits other than 0 and 1. Eg., 1111 ...
BIN2DEC
Converts a binary number into decimal. Syntax BIN2DEC(binary_number) binary_number: The number you want to convert into decimal. It can have a maximum of 10 digits (10 bits), with no digits other than 0 and 1. Eg., 1111 Examples Formula ...
ARABIC
Converts a given Roman numeral into an Arabic numeral. Syntax ARABIC("text") text: The Roman numeral you want to convert into an Arabic numeral. It must be between 1-3999, inclusive. Remarks Returns 0 as the result when an empty string is given ...