View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rockhammer rockhammer is offline
external usenet poster
 
Posts: 57
Default font question #1 - roman numerals

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