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.
COMPUTER TIPS