Convert Roman Numerals to Arabic Numbers in Office 2013


show more Converting roman numerals into arabic numbers provides you with in-depth training on Business. Taught by David Rivers as part of the Office 2013 New Features show less
please wait ...

Converting roman numerals into arabic numbers

If you ever need to work with Roman numerals and Arabic numbers, this next new feature in Excel 2013 might be of interest to you. It's the ability to not only convert to Roman numerals, but also to convert Roman Numerals back to Arabic numbers. We're going to explore it using this spreadsheet named, No Obstacles Sport - July 2012 Sales Report_short. All we're going to do is add a column heading here at Cell F6. We'll type in ROMAN, and press enter. And now, as you can see we have a Size column using Arabic numbers and we want the Roman equivalent over here.

Depending on our location where we're selling our product, we may need to use one or the other. So, we could type in the Roman numeral for seven, which is a VII. When you press Enter, we now have text in there. Now, of course we could also do the conversion like we always could before. Let's use a formula here in the next cell, which is column F, row 8. We'll start with =roman( and what we want to do is conver...

Converting roman numerals into arabic numbers
Video duration: 2m 42s 2h 31m Appropriate for all

Viewers:

Converting roman numerals into arabic numbers provides you with in-depth training on Business. Taught by David Rivers as part of the Office 2013 New Features

Subject:
Business
Software:
Office
Author:
please wait ...