reference the under and over scores, the appearance of the characters is
based on the font used to display them.

If you want a font to display the number 8 as VIII, you would need a
specialty font. But this would only work for integers 0 to 9. If you want
to have a font that displays 12 as XII, then I think you are out of luck.

It would be really nice if there is a font which comes standard with MS
Office

nope.

--
Regards,
Tom Ogilvy


"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