Print

Typing degree symbol One of the most important properties in the summary of soil mechanic tests is the internal friction angle. However, the person who is in charge of data input has trouble typing a degree symbol in Excel.

1) For example: we need to type the value: 12°45´

  Typing method
Illustration
Method 1 Degree value, minute value, degree symbol, minute symbol are typed in separate columns

Column A: type number 12

Column B: type a degree symbol: °

Column C: type number 45

Column D: type a minute symbol: ´

degree method1
Method 2 Use a lower character ‘o’ with superscript format to represent for a degree symbol

1) Type 12o45´

2) Select the lower letter “o”

3) Select: Format > Cells... > Superscript

Result: 12o45´

text input

format cells

superscript

Method 3 Use a degree symbol (ASCII code of 176) and minute symbol (ASCII code of 180) which are available in Windows Unicode fonts.

1) Type a number 12

2) Type a degree symbol

3) Type a number 45

4) Type a minute symbol

Result: 12°45´

 
Method 4 Type only the degree value and minute value with no degree symbol or minute symbol.

Excel will fill up degree symbol and minute symbol at the right positions.

1) Type 1245

2) Select: Format > Cells... > Number > Custom: 0°00´

Result: 12°45´

num input

degree format

Method 5 Convert degree-minute-second value to decimal degree value which is in turn converted to a relevant time value.

Apply Time format to display degree symbol and minute symbol for the angle.

1) Convert a degree-minute value 12°45ˊ to decimal degree value: 12.75

2) Convert to time value: type the formula: =12.75/24

3) Select: Format > Cells... > Number > Custom: [h]° mmˊ

Result: 12°45´

time format

2) Comparison among typing methods:

  Typing convenience
Display Direct calculation with degree values
Method 1 accept16 cancel16 accept16
Method 2 cancel16 accept16 cancel16
Method 3 cancel16 accept16 cancel16
Method 4 accept16accept16 accept16 question16
Method 5 cancel16cancel16 accept16 accept16accept16

3) How to type some special symbols:

Symbol Display Typing method
degree ° Alt + 0176
minute ´ Alt + 0180
square ² Alt + 0178
cubic ³ Alt + 0179
multiplication × Alt + 0215
    (Press and hold Alt key and type number keys on the numpad)