Pages

13 August 2009

Fromat month as roman number in Excel

I needed in one excel file the date - but only month and in roman numbers.
So here is the solution in case someone needs it:
Enter date in cell a1: 01.01.2009
Enter this formula in b1: =ROMAN(MONTH(A1))
Result in b1: I

No comments:

Post a Comment