ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Create Roman numbers

Sometimes you need to display a Roman number. The simple numbers are easy to create, but when the numbers are large most peple have trouble getting them right. The function ROMAN(number,form) will display Roman numbers between 1 and 3999. The argument form is optional and can be omitted, but can also be used to tell how the Roman number is to be displayed.

Examples :

Formula : Returns : Form :
=ROMAN(1995) MCMXCV classical
=ROMAN(1995,1) MLMVL simple
=ROMAN(1995,2) MXMV more simple
=ROMAN(1995,3) MVM even more simple
=ROMAN(1995,4) MVM simplest


Document last updated 2000-02-04 12:45:07      Printerfriendly version


Erlandsen Data Consulting   
Excel & VBA Tips   Copyright ©1999-2024    Ole P. Erlandsen   All rights reserved
E-mail Contact Address