ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert iv - how? (https://www.excelbanter.com/excel-discussion-misc-queries/87209-insert-iv-how.html)

Martin ©¿©¬ @REMOVETHIS.plus.com

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
©¿©¬

Gilles Desjardins

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
©¿©¬




Fred Smith

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
©¿©¬




Martin ©¿©¬ @REMOVETHIS.plus.com

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
©¿©¬

Martin ©¿©¬ @REMOVETHIS.plus.com

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
©¿©¬

Fred Smith

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
©¿©¬




Ragdyer

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
©¿©¬



Martin ©¿©¬ @REMOVETHIS.plus.com

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

Ragdyer

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



Martin ©¿©¬ @REMOVETHIS.plus.com

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
©¿©¬


All times are GMT +1. The time now is 07:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com