Six ways 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.

1. Integer digit + space + fraction

For 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.

Method Advantages and Disadvantages: This method input points convenient, can be calculated, but not beautiful (because we often use vertical notation, so that the input does not conform to our reading habits).

2. Use ANSI code input

For 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).

Method advantages and Disadvantages: The input is not convenient, you want to know the value of the ANSI code represents what is not easy, 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.

3. Formatting cells

For 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", after setting, enter 0.5 in this cell, you can display "1/2".

Method advantages and Disadvantages: the same as the first method.

4. Use Microsoft Formula to enter

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

Methods Advantages and Disadvantages: 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.

5. Custom Input Method

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

Method advantages and Disadvantages: the same as the first input method. This method makes it easy to convert many existing values to fractions of the same denominator.

6. Double line Unification

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.

Methods Advantages and Disadvantages: input convenient, beautiful, but the score can not be calculated.

After reading these input points, do you think that the input score is not a simple question? If you are interested, you can try these methods and experience the mystery.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join