Hello Excellers, today let’s have a bit of fun with formulas. Did you know that Excel had a ROMAN function?. No, I did not either. I love when I discover something new. I will show you how to convert numbers to Roman numerals in Excel.
This little Excel beauty could be used for invitations perhaps, to give a unique look to the date, or for settling arguments on the original dates of TV programs when they are re run on TV.
You know that annoying little date at the end of the credits? (Ok this ones sad but it has come in useful).
The syntax for this formula is
= ROMAN(number,form)
number is the number you want to convert
form is optional and can be any one of the following formats:-
Converting Numbers To Roman Numerals.
Let’s do an example or two, see below:-
Give this little known function ago, it’s quite good fun. Have you ever had to convert numbers to the Roman numeral in Excel?. If you want to watch more tip on VBA and Excel then do feel free to follow my YouTube Channel, Twitter and Facebook Pages where I share all of my FREE Excel and VBA tips.
If you want more tips then sign up for my monthly newsletter where I share 3 Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.
Wantto see all of the blog posts in the Formula Friday series?. You can do so by clicking on the link below.
How To Excel At Excel – Formula Friday Blog Posts.
Macro Monday Blog Posts
Ted says
That’s great, thanks. I was looking for an easy way of telling similar-looking numbers apart, like IX and VIII or 9 and 8.
Lee says
Lovely function, any idea how to get lowercase?
Barbara says
Lee
Yes indeed you can have lowercase
try this =LOWER(ROMAN(CELLREF,TYPE))
Hope that helps
Regards
Barbara
Alex says
How do I create a Fill series using Roman numerals?
Barbara says
HI Alex
There is no no direct way to do this. But what I suggest is type a series of numbers starting in cell A1 for exmaple
1
2
3
4
then in cell B2 use the formula =ROMAN(A1) to reference the values in column A, and drag down, this will give yu the same effect as a fill series of Roman numerals,
Hope that helps
Barbara
prabhu r says
thanks barbara, for your kind information.