NicuMarius blog
Pages
Home
Util
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment