Change the Font
- Set the Font to "Times New Roman".
- You write then for example "V", you get the Roman five.
Formula makes from Arabic to Roman Numbers
If you do not know the correct spelling for a Roman number, Excel can help you. With a formula to convert any decimal number to a Roman.
- Select any cell and enter the following command: =Roman(xxx)
- An example: Type the command: =Roman(456), you will then receive automatically the Roman way of writing "CDLVI".
This practice tip applies to Excel 2010.
