• # 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 ...