How to convert digit list into Roman numerals automatically?

In Microsoft Excel, you can covert the digits list into Roman format automatically. MS Excel allows you to perform conversion by using a mathematical formula. The sentence structure for the Roman function is:

Roman( number, type )

Here number is the any specific digit or cell number that you want to perform conversion to roman and type is optional operator. Roman function will generate error message if you will try to enter here any negative number or values greater than 3999.

To apply a roman formula to MS Excel document, follow the given steps:

First click on Start button, go to Program then click on Microsoft Excel to open a new excel page.

Now enter any list of numbers in cell A1 to cell A15. In this example we are trying to insert any 15 numbers.

Here select the cells B1:B15 and then insert the Roman function =ROMAN(A1) in formula bar.

Now press "Control+ Enter" button to apply this formula to selected areas.