Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to format cells containing integers such that:
a) they show up as roman numerals, i.e., I, II, III, IV, V, etc.; **AND** b) that numbers like V have both an underscore & an "overscore", i.e., a line across the top as well as across the bottom? It would be really nice if there is a font which comes standard with MS Office that would do that because that means I can still use those cells directly in calculations (because they are still numbers, not text). I found the =roman() function interesting but it returns text and does not show the under- & "over-score" (or at least I haven't figured out how to make that work). Any pointers would be appreciated. Rockhammer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CONVERT ROMAN TO ARABIC NUMERALS | Excel Worksheet Functions | |||
How do I convert Roman numerals to Arabic (reverse of ROMAN)? | Excel Worksheet Functions | |||
Possible to have sheet to convert roman numerals? | Excel Programming | |||
Sorting data using roman numerals.... | Excel Discussion (Misc queries) | |||
Function for Roman Numerals | Excel Worksheet Functions |