Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On May 24, 3:11 am, rockhammer
wrote: 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 The roman numeral system was based off your hands (Any roman numeral can be illustrated by your hands. X is crossed fingers thus we only use 3 i letters at a time (you have 5 fingers after all). While the cross bar looks nice you could just use a sign language font for effect ;) Otherwise check fontempire for FIXED width Fonts that have serif's and 0 kerning space. |
Reply |
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 |