From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Using the ROMAN and ARABIC functions to display different number systems

Using the ROMAN and ARABIC functions to display different number systems

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Using the ROMAN and ARABIC functions to display different number systems

“

- Excel has long had a function called ROMAN. It allows us to convert Arabic numbers, the number system most of us use in the western hemisphere, into a Roman numeral. In column A, we've got some numbers, and in column B, the ROMAN's function being used to depict the numbers in Roman numerals. Number of entries here L's, and X's, and M's, and D's, and C's, and so on. Some random numbers over here in column C, and some of these displays in the Roman number conversion are quite lengthy as we see the one here. Notice that the top number that we can use, the highest value we can use is 3,999. If we try and apply the ROMAN function to any number higher than that, we get this kind of an entry here. Now the words is not acceptable, it only goes to 3,999. Starting in Excel 2013, there's a new function, a companion function called ARABIC. Here's some Roman numerals here in column F, and there a little bit on orthodox or a typical, but nevertheless, they are comprised of the letters that we see…

Contents