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

Last modified date

How to use Roman And Arabic functions in Excel

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.
How to convert Normal Numbers to Roman Numbers in Excel
How to convert Arabic Numbers to Roman Numbers in Excel
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

How to convert Normal Numbers to Roman Numbers in Excel
How to convert ARABIC Numbers Example in Excel

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

Formula used in Cell C9=ROMAN(B9)

Result is I

How to convert Roman Numbers to Normal Numbers in Excel
How to convert ROMAN Numbers Example in Excel

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

Formula used in Cell C23=ARABIC(B23)

Result is 1

1 Response

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment