Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to insert iv (4) with a line above and below
How do I do that? Using Office 2003 WINXP Martin ©¿©¬ |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert Options button doesn't disappear | Excel Discussion (Misc queries) | |||
How do I insert a reference to lookup and insert a name | New Users to Excel | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |