What is the Excel formula to change text date to 'pipe' delimited Roman numerals (e.g. June 8, 2009 should be converted to VI|VIII|MMIX.)

Rather than my simplyy posting links to quite a few possible solution, if you do the google trawl/search I did using the string (search words): Roman numerals in excel

you'll get some clearly viable results. Top of the list I got is from MS office support...

You can try this formula: =ROMAN(MONTH(A1))&"|"&ROMAN(DAY(A1))&"|"&ROMAN(YEAR(A1))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think ride and car sharing are the future of transportation?

Discuss in The Lounge

Poll History