Use Excel's ROMAN function if you need to express normal, arabic numbers as Roman numerals.
 |
| Excel's ROMAN function |
Just type "=r" into a cell and you will see a list of Excel functions pop up, then double-click ROMAN in the list to start your formula. If you like using the keyboard then type-in "=ro" and press the TAB key.
Enter the reference of the cell containing the number you want converted and you're done. Excel's ROMAN function converts positive numbers up to a maximum of 3999. The optional Form argument gives you a choice of up to four degrees of simplification of the classic roman form. For example, the value of 2500 can not be simplified and is expressed as roman MMD. However, 2499 is MMCDXCIX in the classic form but MMID in the simplified form.
Enter your formula as =ROMAN(E6,FALSE) for the simplified form or use a number from 1 to 3 for the less simplified forms, i.e. =ROMAN(E6,2) gives you MMXDIX. I'm glad we don't have to use roman numerals in our Excel worksheets, no wonder Maximus* was always in a bad mood.
 |
| Excel's 2013 ARABIC function |
If you've got a copy of Excel 2013 you can convert roman numerals to arabic using the ARABIC function which was introduced with this version.
"My name is Maximus Decimus Meridius, commander of the Armies of the North, General of the Felix Legions, loyal servant to the true emperor, Marcus Aurelius. Father to a murdered son, husband to a murdered wife. And I will have my vengeance, in this life or the next."
*Sorry, I just had to.
*Sorry, I just had to.
Related Posts
Training Courses
If you've still got that "I just don't know what I'm doing" feeling then you might like to arrange an Excel training course for yourself or with some of your colleagues. It's really easy to book one of our courses and they're great value for money. See our website for full details.
No comments:
Post a Comment