How to Convert Arabic Numbers to Roman Numbers in Excel with Formulas? – Do it like this

you may have one spreadsheet in excel with a series of Arabic numerals that you need to convert to Roman numerals. In such a case, it is convenient for you to know how to convert Arabic numbers to Roman numbers in Excel with formulas. Do it like this, in the simplest and most effective way as we show you in this practical tutorial.

What is the function used to change the format of your numbers in Excel?

it’s possible change the format of numbers in excel. To do this, you’ll need a function called ROMAN.NUMBER that you’ll need to insert into a formula using a cell reference to extract the number or data you want to convert or type the number directly.

If you want to convert Roman numbers to Arabic numbers, you will need to use Excel functions such as MATCH, INDEX, ROMAN.NUMBER, ROW, and INDIRECT. MATCH will be added to a formula as the main function, while the other functions will be the parameters that include the number to convert and the match value ‘0’.

How is this function used for number conversion in Microsoft Excel?

There are various ways to use the ROMANNUMBER function for number conversion in Microsoft Excel. Either through the formula bar, writing the function syntax with its parameters manually, using the desktop version of Excel, Excel Live on the web or from a mobile device with the Google Sheets App.

From the desktop version

You can use the ROMAN.NUMBER function to convert Arabic numbers to Roman numbers from the desktop version. Access Microsoft Excel and open the spreadsheet containing the values ​​you want to convert or type a list of Arabic numbers. Place your cursor in the cell where you want to see the conversion result and click ‘fx’.

Immediately, you will see the wizard for creating formulas in Excel. Type in the search box ROMAN.NUMBER and press ‘Go’. Click on this function and press ‘OK’. Click on the arrow next to the ‘Number’ parameter in order to select the cell where the first Arabic number in the list is located and press ‘OK’.

In this way, you will be able to see the result of the conversion of an Arabic number to a Roman number according to the reference that you have added to the formula. To make the conversion of others list valuesclick in the lower-right corner of the cell where the formula is, and drag the cursor to the last item in the number range.

with website

You can also convert Arabic numbers to Roman numbers with the ‘Excel Liv’ website. To do it sign in with your Microsoft account and double-click ‘+ new blank workbook or open the file containing the list of numbers you want to convert using the ‘Load and open’ option.

Once you have the list of Arabic numbers in the Excel spreadsheet, place the cursor in the cell where you want see the conversion result, press the ‘fx’ button and choose the ‘Mathematics and trigonometrics’ category. Locate the ‘ROM.NUMBER’ function and press the ‘OK’ button.

Immediately, the formula will be displayed in the cell you selected in the previous step so you can add parameter. Select the cell range that contains the Arabic numerals, and lastly, type the closing parenthesis and press the ‘Enter’ key in order to execute the formula.

In the mobile version

Similarly, it is possible to convert an Arabic number to a Roman number in the mobile version. To achieve this, download the Google Sheets app from the Google Play Store. After install the App on your deviceaccess this tool and click on the cell where you want to see the conversion result.

Next, press ‘fx’ and select the ‘Mathematics and Trig’ category. Click on ROMAN NUMBER and press ‘Done’. You can too enter the function manually, writing in the cell = ROMAN.NUMBER (parameter). Replace ‘parameter’ with the Arabic number and click ‘Done’ to execute the function.

You can use Kutools extension to convert Arabic numbers to Roman numbers in Excel. In this regard, download and install Kutools on your computer. Next, open Microsoft Excel and find the ‘Kutools’ tab. Click on ‘Content’ and choose ‘Convert between roman and numerals’. Check the ‘Number to roman’ box, press ‘Apply’ and ‘Ok’.

Can operations be done directly with Roman numerals in Excel?

It is possible to do operations directly with Roman numerals in Excel like convert them to arabic numbers. Click the cell where you want to see the conversion, type =MATCH(A1,INDEX(ROM.NUMBER(ROW(INDIRECT(‘1:4000’))), 0), 0) where ‘A1’ is the cell that has the Roman numeral.