Join David Rivers for an in-depth discussion in this video Converting roman numerals into arabic numbers, part of Office 2013 New Features.
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 …
- Exploring the new user interface
- Using the bookmark feature
- Inserting online video in Word documents
- Editing PDFs in Word
- Filtering records using the timeline in Excel
- Exploring new slide transitions in PowerPoint
- Creating web apps for SharePoint or Office 365 with Access
- Inserting online pictures with Publisher
- Embedding files in a OneNote notebook
- Connecting to social networks with Outlook
Skill Level Intermediate
1. Suite-Wide Enhancements
Using the Weather bar1m 42s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.