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…convert this number over here in cell D8, so we will click there and then close it up …