A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

HOW TO GET ROMAN LETTERS



 
 
Thread Tools Display Modes
  #1  
Old September 11th, 2005, 04:14 PM
Venu
external usenet poster
 
Posts: n/a
Default HOW TO GET ROMAN LETTERS

i wanted the numbers 1,2,3 in roman letters please how to do that
  #2  
Old September 11th, 2005, 04:37 PM
JoAnn Paules [MSFT MVP]
external usenet poster
 
Posts: n/a
Default

This sounds like a homework question - which we don't answer. Perhaps if you
knew that the proper term is Roman numerals that might help.

--

JoAnn Paules
MVP Microsoft [Publisher]



"Venu" wrote in message
...
i wanted the numbers 1,2,3 in roman letters please how to do that



  #3  
Old September 11th, 2005, 04:38 PM
Mike Hall \(MS-MVP\)
external usenet poster
 
Posts: n/a
Default

I, II, III, IV, V, VI, VII, VIII, IX, X, XI, XII, XIII, XIV, XV, XVI, XVII,
XVIII, XIX, XX..

Use the upper case i..

--
Mike Hall
MVP - Windows Shell/User


"Venu" wrote in message
...
i wanted the numbers 1,2,3 in roman letters please how to do that



  #4  
Old September 11th, 2005, 05:58 PM
Mary Sauer
external usenet poster
 
Posts: n/a
Default

Shortcut Keys
2160, alt+x I
2161, alt+x II
2162, alt+x III

and so on...

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"Venu" wrote in message
...
i wanted the numbers 1,2,3 in roman letters please how to do that



  #5  
Old September 11th, 2005, 06:42 PM
Mike Hall \(MS-MVP\)
external usenet poster
 
Posts: n/a
Default

Mary

It is surely easier to type them.. :-)

--
Mike Hall
MVP - Windows Shell/User


"Mary Sauer" wrote in message
...
Shortcut Keys
2160, alt+x I
2161, alt+x II
2162, alt+x III

and so on...

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"Venu" wrote in message
...
i wanted the numbers 1,2,3 in roman letters please how to do that





  #6  
Old September 11th, 2005, 06:53 PM
James Silverton
external usenet poster
 
Posts: n/a
Default



--
James Silverton, Potomac, Maryland
"Mike Hall (MS-MVP)" wrote in
message ...
Mary

It is surely easier to type them.. :-)

--
Mike Hall
MVP - Windows Shell/User


"Mary Sauer" wrote in message
...
Shortcut Keys
2160, alt+x I
2161, alt+x II
2162, alt+x III


If there were a method to readily translate large numbers, say
like 2005, into Roman numerals it might be worth knowing but,
otherwise, I'd say Mike is right. Mary's method finishes with
translating 2169 into X.


--
James Silverton, Potomac, Maryland

  #7  
Old September 11th, 2005, 07:52 PM
Bernard Liengme
external usenet poster
 
Posts: n/a
Default

Go into Excel and search help for the ROMAN function
Works with numbers less than 4000

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Venu" wrote in message
...
i wanted the numbers 1,2,3 in roman letters please how to do that



  #8  
Old September 11th, 2005, 08:07 PM
James Silverton
external usenet poster
 
Posts: n/a
Default

Bernard wrote on Sun, 11 Sep 2005 15:52:43 -0300:

BL Go into Excel and search help for the ROMAN function
BL Works with numbers less than 4000

Thanks, I knew about that one and its variations :-). It's
rather amusing to calculate them mentally on the rare occasions
that I need them. The other way round is actually a little more
common for me but it's only for working out the copyright dates
on movies etc.

James Silverton.

  #9  
Old September 12th, 2005, 01:18 AM
Herb Tyson [MVP]
external usenet poster
 
Posts: n/a
Default

In Word, you can use a field code with the \*roman switch to do the
"translation" for you.

1. Press Ctrl+F9 to insert the field braces, { }

2. Type =1 \*ROMAN between the field braces, so you now have { =1
\*ROMAN}

3. Press F9 to "update" the field, and it will resolve to i.

It's much more impressive with larger numbers, though. For example, you can
use:

{ =2005 \*ROMAN }

to discover that the current year is MMV, or { =5280 \*ROMAN } to learn that
there are
MMMMMCCLXXX feet in I mile. If you use { =0 \*ROMAN}, you'll see that a 0 in
Roman numerals is a space. That's because the Romans didn't have a zero.
They would've had to invent one if they'd taught where I went to high
school, though.



Hope this helps...


--
Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com
"Venu" wrote in message
...
i wanted the numbers 1,2,3 in roman letters please how to do that



  #10  
Old September 13th, 2005, 02:45 AM
Gary Smith
external usenet poster
 
Posts: n/a
Default

Indeed it is, but the results are different. Typing "III" gives you three
repititions of the letter I. Typing 2162,Alt-X gives you a single
character representing the Roman numeral three. Even though they look the
same, they behave quite differently.


"Mike Hall \(MS-MVP\)" wrote:
It is surely easier to type them.. :-)


"Mary Sauer" wrote in message
...
Shortcut Keys
2160, alt+x I
2161, alt+x II
2162, alt+x III

and so on...


--
Gary L. Smith
Columbus, Ohio
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Mail Merge to Word.doc files ? RNUSZ@OKDPS Setting Up & Running Reports 1 May 18th, 2005 06:31 PM
Printing pages with roman page numbers and in different sections? bandy2000 General Discussion 2 April 12th, 2005 01:28 AM
Form letters to new records only LReber New Users 2 November 9th, 2004 08:25 PM
Formula help - looking at last two letters in multi-letter text string in single tim Worksheet Functions 2 August 19th, 2004 09:29 PM
excel - changing upper case letters into lower case letters BJorg Worksheet Functions 4 February 16th, 2004 08:40 AM


All times are GMT +1. The time now is 11:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.