How to enter fractions in Excel

Excel is really powerful in mathematical statistics, but there are some things that are not satisfactory in detail, such as the need to enter a score, which has some learning. We are now collecting six common methods to share with you.


one, integer digit + space + fraction


Example: To enter One-second, you can enter: 0 (space) 1/2; If you want to enter one or One-third, you can enter: 1 (space) 1/3.

Advantages and disadvantages of the
method: This method is easy to input, can be calculated, but not beautiful (because we often use vertical notation, so the input does not conform to our reading habits).


Two, use ANSI code input


Example: To enter One-second, you can first hold down the "alt" key, and then enter "189", and then release the "Alt" button ("189" to use the keypad input, the large keyboard input is invalid).

Advantages and disadvantages of the
method: the input is not convenient, you want to know the value of the ANSI code is not easy to represent, and the input value can not be calculated. However, the score shown in this method is more beautiful, and you can use this method to enter some unusual symbols, units, and so on. An introduction to using this input method to enter currency symbols is available in Excel Help.


three, set cell formatting


Example: To enter One-second, you can select a cell, use the menu "format/Cell format", select "category" As a score, type "denominator for a number of", set up, enter 0.5 in this cell, you can display "1/2".

Advantages and disadvantages of
method: Same as the first method.


Four, enter
using Microsoft Formula

We can use the menu "Insert/object" to find "Microsoft Formula 3.0" in the object type, (OK) to appear in the Formula Editor (Formula Editor requires a custom installation, if not installed, prompts to put the Office CD-ROM, as prompted to operate), We can enter fractions in the same way that the formula Editor is used in Word. (www.3lian.com)

Advantages and disadvantages of the
method: The input is very beautiful, easy to typesetting, consistent with the daily writing of the habit of fractional, but the input score can not be calculated.


Five, custom input method


For example: To enter One-second, first select the cell, use the menu "format/Cell", select "Custom" in the category of "number", and enter the type: # (space) 1/2.

Advantages and disadvantages of the
method: Same as the first input method. This method makes it easy to convert many existing values to fractions of the same denominator.


Six, two lines of unity


This method is to use the bottom border of the table as the horizontal bar of the fractional, enter the numerator in a cell, set the cell to have the bottom border, and enter the denominator in the next cell of the same column. For the sake of beauty, we can set the other cells to a no-frame line, and then set the background fill color to white.

Advantages and disadvantages of
method: The input is convenient and beautiful, but the score cannot be calculated.