| ERLANDSEN DATA CONSULTING |
Excel & VBA Tips
|
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
http://www.erlandsendata.no/
Excel & VBA Tips Copyright ©1999-2024 Ole P. Erlandsen All rights reserved 
|