LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONVERT ROMAN TO ARABIC NUMERALS JOHN Excel Worksheet Functions 7 April 14th 10 12:09 PM
How do I convert Roman numerals to Arabic (reverse of ROMAN)? IanW[_2_] Excel Worksheet Functions 5 May 4th 07 12:50 PM
Possible to have sheet to convert roman numerals? StargateFan[_3_] Excel Programming 3 September 11th 05 02:05 PM
Sorting data using roman numerals.... Hokie Bear Excel Discussion (Misc queries) 7 August 19th 05 10:05 PM
Function for Roman Numerals Gary's Student Excel Worksheet Functions 6 April 27th 05 08:25 PM


All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"