Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Please post any suggestions or ideas that you think the ExcelCalcs team should consider.
Go to bottom Favoured: 0
TOPIC: Overline
#3245
sanderson519 (User)
Egg (Fresh Boarder)
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Overline 3 Years, 9 Months ago Karma: 0  
Does xlc have a way to easily add an overscore, or overline to a letter? Overscores often show up in equations and it is cumbersome to add them in excel the normal way.
 
Logged Logged  
  The administrator has disabled public write access.
#3246
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Overline 3 Years, 9 Months ago Karma: 493  
You sent me on an interesting goose chase but I think I have found a solution for you which requires no changes to XLC.
Insert a special unicode character called on overline combining diacritical mark... sounds complicated but all you need to do to get X bar is:
Type "X"
Press and hold down the Alt key.
on the number keypad type +0305 (all numbers and the + must be entered via the keypad mind)
Release the Alt key.
press "=" so it becomes an XLC name
you will get Xbar. This works to put an overline on any character.

Just one word of caution it may look that you have one character but you do have two characters so if you name using the " =" name convention to make XLC automatically subscript characters after the first it can screw things up.

Thanks for the good question and I am please to have learned something too.
 
Logged Logged  
 
  The administrator has disabled public write access.
#3247
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Overline 3 Years, 9 Months ago Karma: 493  
Just a quick look at my test:
 
Logged Logged  
 
  The administrator has disabled public write access.
Go to top
We have 10 guests and 38 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative