Hello Excellers, today let’s have a bit of fun with Excel formulas.
Did you know that Excel had a ROMAN function?, Me neither, I love when I discover something new 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
number is the number you want to convert
form is optional and can be any one of the following formats:-
Let’s do an example or two, see below:-
Give this little known function a go, it’s quite good fun.
If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.
If you want to see all of the blog posts in the Formula Friday series you can do so by clicking on the link below.