Lesson#24: ROMAN, ARABIC in excel

Lesson#24: ROMAN, ARABIC in excel

In this post, we will discuss two formula which converts the Roman number system to Arabic and Arabic to  Roman.

Function ROMAN converts the Arabic number system to Roman. Syntax of this function is ROMAN( number, [type] ). Here the number is the digit or you can refer to the cell which contains the number. In the [type] you will get this options 0 – Classic (default),
1 -More concise, 2-         More
concise, 3-More concise, 4-Simplified. 

An example is shown in the above picture.

Now we will discuss the opposite formula which converts the Roman number system to Arabic. Function ARABIC has the syntax ARABIC( text ). It returns a zero value from an empty string (“”). Negative is not supported as roman numeric does not have negative.

Note: ARABIC is not supported in Office 2007 or the lower version.

See also  Lesson#243: SEARCH and FIND Functions in Excel: Unleashing Text Search Power

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

*