Solved Change Text Date to Roman Numerals

February 22, 2016 at 14:31:02
Specs: Windows XP
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.)

See More: Change Text Date to Roman Numerals

Report •

#1
February 22, 2016 at 16:06:26
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...


Report •

#2
February 22, 2016 at 16:36:31
✔ Best Answer
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.


Report •
Related Solutions


Ask Question