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 …
Author
Released
1/29/2013- 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
Duration
Views
Related Courses
-
Word 2013 Essential Training
with David Rivers5h 9m Intermediate -
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate
-
Introduction
-
Welcome59s
-
-
1. Suite-Wide Enhancements
-
Integrating with the cloud3m 42s
-
Exploring Touch mode2m 53s
-
Using the bookmark feature2m 18s
-
2. Word
-
Inserting online video4m 4s
-
Editing PDF documents4m 58s
-
-
3. Excel
-
4. PowerPoint
-
Working with new templates3m 29s
-
Using color adjustments2m 59s
-
Inserting new charts8m 37s
-
Creating a custom shape4m 31s
-
-
5. Access
-
6. Publisher
-
7. OneNote
-
Changing views4m 8s
-
Inserting a screenshot2m 21s
-
8. Outlook
-
Using the Weather bar1m 42s
-
Conclusion
-
Next steps29s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Converting roman numerals into arabic numbers