Overscore

[Philosophaie]

How do you put a line over a letter in Excel?

 

[jim may]

furnish an example, please..

 

[Philosophaie]

In Roman Numerals there is a Bar over V. That repesents 5000. I want to be able to print the letter V with a bar over it as one single character just a you can underline something by clicking on the U.

 

[jasonb75]

http://www.contextures.com/xlfaqFun.html#bar

 

[Philosophaie]

Having trouble with the Symbols Font. Everytime I type "`V" It change to another Font Type which contains no overscore. I do not want to go thru all the fonts to find the one with overscores so could someone tell me which Font in Symbols contains Overscores.

 

[shg]

Only the first character is in Symbol font. Change the second character to any font you like (e.g., whatever you use for Normal).

If you're editing the cell, insert the character after the V, then delete the V:

'V => 'VA => 'A

 

[jasonb75]

Why insert and then delete again shg?

I tried it before posting th elink to verify that it worked, all I did was select the symbol font, press ` return to calibri font, then press V

It doesn't show while the cursor is still in the cell, but when you press return the fonts "merge".

 

[Philosophaie]

When you type ` into Symbols it takes you to the font: AcadEref. It does not have any Alphabets with bars over them and there are no "V" in there plus the "A" that is there does not print out with a bar over it. How do I get an overscore?

 

[VoG]

Click in a cell

Set its font to Symbol

Type ` in the cell

Set the font to Arial or whatever

Type V in the cell.

 

[jim may]

Click in a cell

Set its font to Symbol

Type ` in the cell - DO NOT PRESS THE ENTER KEY (Leave Undone, in Suspense)

But then,

Set the font to Arial or whatever

Type V in the cell. NOW PRESS THE ENTER KEY (Commit).

Does that Help?