Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 with a closing round bracket and press Return.
You can see we get the same thing. We get a Roman numeral here. Now, when we click in that cell we see up here in the Formula Bar, the actual formula that gives us that. It is text, just as we see text in the cell above. Clicking in cell F7 shows the text in the Formula Bar. It really doesn't matter how we get it, we're looking at text. Now, if wanted to, we could just copy this formula all the way down. Click in cell F8, go to the bottom right-hand corner and we'll just click and drag all the way down to the bottom of our data.
So, we've got to go quite away all the way to row 69 and let go and you can see everything is converted nicely. Okay. Now, let's say we didn't have these numbers here in the Size column. Let's say they didn't exist and we wanted to add them. We can use a formula now, this is the new part, to convert Roman Numerals over to Arabic numbers. So, let's just type in ARABIC and hit Return, and now the formula just like the conversion to Roman numerals we use the Equal sign (=), but this time we type Arabic. That's the new part. An opening round bracket, we'll click in the text field here showing us the Roman numeral VII, and when we close it up with a closing round bracket and press Return, as you can see it's converted to an actual number.
So, the formula shows up in the Formula Bar, but the number is displayed. Again, we could click and drag from the bottom corner to copy that formula all the way down getting our actual Arabic numbers out of the text version of the Roman numeral. So, that's what's new here in Excel 2013 when converting to Arabic from Roman Numerals.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74485 Viewers
80 Video lessons · 129702 Viewers
52 Video lessons · 63944 Viewers
59 Video lessons · 49729 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.