How to get a ROMAN number in Excel (ROMAN and ARABIC Functions)

Click Here to download the Excel File which contains the Below Examples.

Description of Functions

ROMAN Function:- This Function will help to convert Arabic Numbers(1,2,3……..) to Roman Numbers(I, II, III, IV…….).

ARABIC Function:- This Function will help to Convert Roman Numbers(I, II, III, IV…….) to Arabic Numbers(1,2,3……..).

Note:- ARABIC Numbers means 1,2,3,4,5…….

The Syntax of Functions

ROMAN Function

ROMAN(number,[form])

1st Argument(Compulsory): number

2nd Argument(optional): [form]

ARABIC Function

ARABIC(text)

1st Argument(Compulsory): text

Description of Arguments

Roman Function

• number: 1st Argument(Compulsory) select the number which we want to convert in ROMAN number style.
• [form]: 2nd Argument(Optional) here we need select options to use different methods to write the ROMAN numbers. Total of 5 methods available from 0 to 4. If 2nd argument is ignored default method 0 is used.
• If you are not sure which option to select in the 2nd argument you can ignore it.
• Please see below the example of 5 different method results.

ARABIC Function

text : 1st Argument(Compulsory) here we need to select the ROMAN number to convert to normal numbers(Arabic Numbers)

Explanation of ROMAN and ARABIC Functions with Examples

Example 1: Convert ARABIC Numbers(1,2,3,…..) to ROMAN numbers().

Formula used in Cell C9=ROMAN(B9)

Result is I

Example 2: Convert ROMAN Numbers(I, II, III……) to ARABIC numbers

Formula used in Cell C23=ARABIC(B23)

Result is 1