 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / October 2006overline in Excel
Is there any way to create an overbar over text in a text box in an Excel drawing? Before you type the character for which you want the overbar, change the font to Symbol. To create the bar, type the ` character (accent grave, may be above the Tab key) Then, stay in Symbol font, or switch to a different font, and type the character that has the overbar. > Is there any way to create an overbar over text in a text box in an Excel > drawing?  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Wonderful! Why have you kept this a secret for so long <gr> ? I have seen this question so many times. Will buy you a drink at the next Excel Users Conf! best wishes SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Before you type the character for which you want the overbar, change the > font to Symbol. [quoted text clipped - 5 lines] >> Is there any way to create an overbar over text in a text box in an Excel >> drawing? Hello, Bernard! You wrote on Tue, 31 Oct 2006 09:47:58 -0400: BL> Wonderful! Why have you kept this a secret for so long <gr> BL> ? I have seen this question so many times. Will buy you a BL> drink at the next Excel Users Conf! BL> best wishes BL> -- BL> Bernard V Liengme BL> www.stfx.ca/people/bliengme BL> remove caps from email BL> "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in BL> message news:45468D14.40304@contexturesXSPAM.com... ??>> Before you type the character for which you want the ??>> overbar, change the font to Symbol. To create the bar, ??>> type the ` character (accent grave, may be above the Tab ??>> key) Then, stay in Symbol font, or switch to a different ??>> font, and type the character that has the overbar. ??>> I wonder if the OP would consider posting this tip elsewhere? I'd never heard of it before and I use Word a lot! There are some problems in that the character is actually (space)-overline but it is most useful. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not I'm glad you like it! I've added it to the FAQs here: http://www.contextures.com/xlfaqFun.html#bar And thanks Bernard, I look forward to that free drink. <g> > Hello, Bernard! > You wrote on Tue, 31 Oct 2006 09:47:58 -0400: [quoted text clipped - 25 lines] > > E-mail, with obvious alterations: not.jim.silverton.at.comcast.not SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html > Before you type the character for which you want the overbar, > change the font to Symbol. [quoted text clipped - 5 lines] >> Is there any way to create an overbar over text in a text box >> in an Excel drawing? Interesting! A most unusual capability for a Microsoft font but it only seems to work in an Excel text box. If you use it elsewhere you only get an overlined Greek character from those available in Symbol. The formula bar may well indicate the desired character but that's not what I got! For example, I tried to get a bar over an x. The overline apppeared in Symbol font; I switched to Arial, typed x and got an overlined lower case Greek xi while the Formula bar showed `x (side by side as here). SignatureJames Silverton Potomac, Maryland It works well in a cell, also SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >> Before you type the character for which you want the overbar, change the >> font to Symbol. [quoted text clipped - 14 lines] > Symbol font; I switched to Arial, typed x and got an overlined lower case > Greek xi while the Formula bar showed `x (side by side as here). Hello, Bernard! You wrote on Tue, 31 Oct 2006 10:16:52 -0400: BL> It works well in a cell, also BL> -- BL> Bernard V Liengme By heck you are right! I was confused by not following thro' to the end. Taking the case of the overlined x, `x appears in the formula bar after switching from Symbol to Arial and overline xi in the cell but, when ENTER, is pressed, you get overline x.! A most remarkable discovery and it seems to work in Word too. BL> "James Silverton" <not.jim.silverton@comcast.not> wrote in BL> message news:%23%23fbzMP$GHA.4300@TK2MSFTNGP03.phx.gbl... ??>> "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in ??>> message news:45468D14.40304@contexturesXSPAM.com... ??>>> Before you type the character for which you want the ??>>> overbar, change the font to Symbol. To create the bar, ??>>> type the ` character (accent grave, may be above the Tab ??>>> key) Then, stay in Symbol font, or switch to a different ??>>> font, and type the character that has the overbar. <<<<snipping my post>>>>>>>>>>>>>>>>>>> James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.