Tuesday, July 16, 2013

Adding an overbar to a letter in MS Word

When expressing the average like Y bar, this can be done in word by inserting a field code (CTRL F9), then creating the code as follows: { EQ \O (Y, ¯)}. The way you get the character ¯ to appear is by holding down the alt key, then typing the number sequence 0175. This is the ASCII code for an overbar.

VBA Excel to Double Click change to checkmark or x

 Note that to do this, you need to set the font of the affected cells to Winding 2 first: 1 2 3 4 5 6 7 8 9 10 11 12 Private Sub Worksheet...