Roman Numerals

Have you ever needed to use Roman numerals and just typed them in manually? What happens when you need to type in a value of 100? Do you know the Roman numeral for that?

There is a very simple solution:

excelguy.co.za

=ROMAN (number, [form])

  • number – Number (in Arabic numeral) you want to convert to Roman numeral.
  • form – [optional] The type of Roman numeral you want.

You can type in =ROMAN(4) which will return “IV”, or you can reference a cell like I have done in the image. =ROMAN(D6) which will return “I”

Quick, easy and cuts out having to lookup the correct Roman numeral.