font question #1 - roman numerals

[Guest]

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

 

[Keith74]

Found this on msdn

http://support.microsoft.com/kb/184657

hth

Keith

 

[Guest]

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.

 

[Guest]

Thanks, Tom & Keith for you replies.

I suppose using =roman() to convert to text and the lack of over/underscores
are not end of the world!

Patrick.

 

[Idgarad]

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.