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

Watch on YouTube

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