#1   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @REMOVETHIS.plus.com
 
Posts: n/a
Default Insert iv - how?

I'm trying to insert iv (4) with a line above and below
How do I do that?

Using Office 2003
WINXP

Martin
©¿©¬
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gilles Desjardins
 
Posts: n/a
Default Insert iv - how?

Upper case I and V in times New Roman????

Is that what you want?


<Martin ©¿©¬ @REMOVETHIS.plus.com wrote in message
...
I'm trying to insert iv (4) with a line above and below
How do I do that?

Using Office 2003
WINXP

Martin
©¿©¬



  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default Insert iv - how?

Do you want to do this in Word or Excel? By 'iv' do you mean roman numeral 4,
and do you mean it needs to follow a 'iii'?

--
Regards,
Fred


<Martin ©¿©¬ @REMOVETHIS.plus.com wrote in message
...
I'm trying to insert iv (4) with a line above and below
How do I do that?

Using Office 2003
WINXP

Martin
©¿©¬



  #4   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @REMOVETHIS.plus.com
 
Posts: n/a
Default Insert iv - how?

On Sat, 6 May 2006 22:14:04 -0600, "Fred Smith"
wrote:

Do you want to do this in Word or Excel? By 'iv' do you mean roman numeral 4,
and do you mean it needs to follow a 'iii'?


Fred, I want to do this in Excel and I mean the roman numeral for 4
with a line above and below

Regards
Martin
©¿©¬
  #5   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @REMOVETHIS.plus.com
 
Posts: n/a
Default Insert iv - how?

On Sat, 6 May 2006 19:43:59 -0400, "Gilles Desjardins"
wrote:

Upper case I and V in times New Roman????

Is that what you want?


Upper or lower Giles, but I want to do it in Excel with a line above
and below

__
IV
_

Regards
Martin
©¿©¬


  #6   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default Insert iv - how?

Assume you want to insert this after row 4.

Highlight rows 5,6 and 7 (put the cursor on row 5, left click and drag to row
7).
Right click, choose Insert.

This will give you three blank rows.
Enter 'iv' wherever you want.

--
Regards,
Fred


<Martin ©¿©¬ @REMOVETHIS.plus.com wrote in message
...
On Sat, 6 May 2006 22:14:04 -0600, "Fred Smith"
wrote:

Do you want to do this in Word or Excel? By 'iv' do you mean roman numeral 4,
and do you mean it needs to follow a 'iii'?


Fred, I want to do this in Excel and I mean the roman numeral for 4
with a line above and below

Regards
Martin
©¿©¬



  #7   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default Insert iv - how?

You could try this:

Hit Underline twice (on my keyboard, <Shiftdash or minus[right of 0 zero]),
Then <Alt <Enter,
Then key in
IV
Then <Enter.

Then, select the cell again, and click "underline" and "center" from the
toolbar.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<Martin ©¿©¬ @REMOVETHIS.plus.com wrote in message
...
On Sat, 6 May 2006 22:14:04 -0600, "Fred Smith"
wrote:

Do you want to do this in Word or Excel? By 'iv' do you mean roman

numeral 4,
and do you mean it needs to follow a 'iii'?


Fred, I want to do this in Excel and I mean the roman numeral for 4
with a line above and below

Regards
Martin
©¿©¬


  #8   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @REMOVETHIS.plus.com
 
Posts: n/a
Default Insert iv - how?

On Sun, 7 May 2006 09:31:00 -0700, "Ragdyer"
wrote:

You could try this:

Hit Underline twice (on my keyboard, <Shiftdash or minus[right of 0 zero]),
Then <Alt <Enter,
Then key in
IV
Then <Enter.

Then, select the cell again, and click "underline" and "center" from the
toolbar.


Thank you Ragdyer that works great if the IV is in its own cell
However, it is in the middle of text, which is in between other lines
of text

THE KEEPERS HOUSE - by ALAN McMURTRY
THE LIGHTHOUSE - by ALAN McMURTRY
FE IV AT LARNE - by SAM McLARNON
EUROPIC FERRY AT LARNE - by SAM McLARNON
AUTUMN IN CARNFUNNOCK - by T. DRUMMOND
  #9   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default Insert iv - how?

Can be done ... But don't know how "nice" it looks.
Also, don't know if it's worth all the "trouble", but that's your decision.

Select the cell,
Then <F2 <Home

Key in those 2 underlines from the keyboard, then,
<Alt <Enter
Then
<Ctrl <Home,
And add <Spaces to place those underlines over the IV,
Then <Enter.

Click in the cell again, and *IN THE FORMULA BAR*
Select *only* the IV,
Then click the "underline" from the toolbar,
Then <Enter.

Can you use that?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<Martin ©¿©¬ @REMOVETHIS.plus.com wrote in message
...
On Sun, 7 May 2006 09:31:00 -0700, "Ragdyer"
wrote:

You could try this:

Hit Underline twice (on my keyboard, <Shiftdash or minus[right of 0

zero]),
Then <Alt <Enter,
Then key in
IV
Then <Enter.

Then, select the cell again, and click "underline" and "center" from the
toolbar.


Thank you Ragdyer that works great if the IV is in its own cell
However, it is in the middle of text, which is in between other lines
of text

THE KEEPERS HOUSE - by ALAN McMURTRY
THE LIGHTHOUSE - by ALAN McMURTRY
FE IV AT LARNE - by SAM McLARNON
EUROPIC FERRY AT LARNE - by SAM McLARNON
AUTUMN IN CARNFUNNOCK - by T. DRUMMOND


  #10   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @REMOVETHIS.plus.com
 
Posts: n/a
Default Insert iv - how?

On Sun, 7 May 2006 11:34:36 -0700, "Ragdyer"
wrote:

Can be done ... But don't know how "nice" it looks.
Also, don't know if it's worth all the "trouble", but that's your decision.
Select the cell,
Then <F2 <Home
Key in those 2 underlines from the keyboard, then,
<Alt <Enter
Then
<Ctrl <Home,
And add <Spaces to place those underlines over the IV,
Then <Enter.
Click in the cell again, and *IN THE FORMULA BAR*
Select *only* the IV,
Then click the "underline" from the toolbar,
Then <Enter.
Can you use that?


Thank you for you're trouble RagDyer
As you say, it's not really worth the trouble
However, I have learnt something new

Regards
Martin
©¿©¬
Reply
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
Can I auto insert a worksheet when I insert a value in a cell. iainc Excel Worksheet Functions 0 April 27th 06 08:37 AM
Insert Options button doesn't disappear Seraph Excel Discussion (Misc queries) 0 April 25th 06 02:09 PM
How do I insert a reference to lookup and insert a name Jan K New Users to Excel 3 July 20th 05 10:39 AM
insert picture BillGwyer Excel Discussion (Misc queries) 1 March 4th 05 06:37 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM


All times are GMT +1. The time now is 06:20 PM.

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"