Excel - Working With Roman Numerals In Excel Formulas - Episode 1942
1,405 views · Published 21 December 2014 · 6:56 · Indexed 24 October 2026
Channel: MrExcel.com · 2014 · Education
Microsoft Excel Tutorial: ROMAN Numerals in Excel. Welcome to the MrExcel podcast. In this episode, we'll be discussing two of the most obscure and seemingly useless functions in Excel: =ROMAN() and =ARABIC(). These functions may seem like a joke, but they actually have some practical applications that we'll explore in this video. First, let's talk about the =ROMAN() function. This function allows you to convert regular numbers into Roman numerals. While this may seem pointless in today's world, there are still some instances where Roman numerals are used, such as in the NFL's Super Bowl numbering system or in TV and movie credits. However, the real usefulness of this function lies in its comedic value, as demonstrated in my Live Power Excel Seminars. But wait, there's more! Thanks to the open document spreadsheet consortium, Excel 2013 now has a function that does the opposite of =ROMAN(): the =ARABIC() function. This function allows you to convert Roman numerals back into regular numbers. So, if you ever find yourself needing to decipher a Roman numeral, Excel has got you covered. In this video, I also share a personal anecdote about how I used the =ROMAN() function to come up with the title for my 40th Excel book, "MrExcel XL". This book will be a collection of the 40 greatest Excel tips of all time, as voted by my audience. To make this book extra special, I've decided to print it in full color with custom illustrations for each tip. However, this comes at a cost, which is why I've started an IndieGoGo campaign to help cover the expenses. By participating in the campaign, you not only get to help choose the 40 greatest Excel tips, but you also get your name in the book and a chance to receive an autographed copy. So, if you're looking for a unique and geeky gift for yourself or a loved one, consider contributing to the campaign. Your support will not only help make this book a reality, but it will also help keep the MrExcel podcast going strong. Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to check out the IndieGoGo campaign at tinyurl.com/mrxlbook40 and stay tuned for more Excel tips and tricks in future episodes. And remember, the next time you want to confuse your boss, just convert those regular numbers to Roman numerals. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Why is ROMAN in Excel? (00:20) The Joke in Live Power Excel Seminar (00:50) The Ridiculousness of the Function (01:00) The Addition of =ARABIC() Function in Excel 2013 (01:47) Examples of Roman Numerals in Pop Culture (02:56) The Possibility of Jay Z and Beyonce Using the Function (03:11) The Creation of "MrExcel XL" Book (04:01) The Need for Funding through IndieGoGo (05:53) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelformulasandfunctions #romannumerals This video answers these common search terms: how to convert roman numerals to numbers on excel how to make roman numeral on excel how to convert arabic numbers to roman in excel how to use roman numerals in excel convert roman numerals to arabic in excel how to put roman numerals in excel how to type roman numbers in excel excel formula for roman numerals roman numeral functions in excel arabic to roman numerals conversion in excel using roman numerals as data in excel format cells with roman numerals in excel working with roman numerals in excel formulas For the IndieGoGo link: http://tinyurl.com/mrxlbook40 Two of the least useful functions in Excel - ROMAN and ARABIC. Learn why Steven Spielberg, Beyonce, and Enron accountants might be the only people using ROMAN. Plus, an announcement about how you can appear in my 40th Excel book. Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153766/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920