How to enter one and two thirds in excel

Start by formatting the cell or range where you need to enter a fraction.

The format --- cell --- fraction --- denominator is a single digit (1 4) - determined.

Then enter 1, press the blank key, enter molecule 2, enter"/", enter the denominator 3, and press enter.

Yes in the column, 1 in the cell

1. Insert the Microsoft Object formula.

With this formulator you can use any formula and any fraction.

2. Enter "1", then "Space", and then "2 3".

1. Select the cell you want to enter data into.

2. Select "Cells" in the "Format" menu

3. In the "Numbers" tab, select "Fractions". To the right, select the format of the fraction, e.g. one-digit denominator, two-digit denominator, .......

4. You can select "Denominator is one digit" here. Click OK

The above operation is to format cells as fractions.

Now you can enter data in this cell!

Method 1: Enter "" in the cell. At this time, the computer will automatically display "1Method 2: Enter "1 directly in this cell".

2 3", that's it!

I'm afraid that's all there is ......If you want vertical, mathematically fractions, then I'll tell you that there is no way to do it in Excel, only with the formulator in Word...

Kiss. Hello, I am glad to answer for you: how to enter 1/2 fraction in excel A1, click the "Insert" tab - Symbols - Formula, and select "Ink Formula" in the drop-down list.

Some Excel versions can directly select "Fraction" in the drop-down list. 2. In the pop-up "Math Input Control" dialog box, you can write the formula by hand with the mouse. 3. After the handwriting is completed, click the "Insert" button to insert the score into **.

The score can be changed at any time by insertion, but the disadvantage is that it is equivalent to an inserted text box object and cannot participate in the operation. I hope mine is helpful to you, I wish you a happy life, if mine is helpful to you I hope you can give a 5 star like. Thank you for your support.

In Excel, format the data of the cell as a fraction first. Then you can use the keyboard to enter 1 2 if you want to enter 1 2. If one and a third, enter 4 3.

At the same time, the input fraction format can participate in the calculation. Specifically, take Excel2007 as an example, and the setting method is as follows:

1. Open Excel2007 on the computer.

2. Select the cell you want to enter the fraction in, right-click and select Format Cell.

3. In the settings screen that appears, click on the number. Then, select the score and select the specific score type, and click the OK button.

4. At this time, if you need to enter one-half, enter 1 first, then enter the slash on the shift side of the keyboard, and then enter 2.

5. If you need one and a third, enter 4 first, and then enter the slash user enters 3.

6. At this time, you can test the result of the operation, such as 1 2 plus 4 3 The result is 11 6, then the result displayed is 1 and 5/6.

In Excel, the fraction is 1 and 1/2, which can be achieved by inserting and inserting formulas.

The steps of the method are as follows:

1. Open the Excel** you need to operate, find and click "Formula" in the Insert tab.

2. Find the score in the formula designer and select a score display style.

3. Enter the numerator denominator in the box below and below the dividing line, return to excel**, and find that the score has been successfully entered in excel.

First of all, format the cell as a fraction, the denominator is in the optional, if you want to enter 1 and 1 3, then enter 4 3, if you just want to display the score up and down in excel, you can merge the cells to do.

The method of entering 0 spaces is feasible (see the animation for details) Excel version reference: 20101, select A1 cell 2, enter 0 (space) 1 23, press enter to complete.

Right-click on the selected cell in the drop-down menu Select Format Cell Select Fraction Select the desired type (number of digits of the denominator).

Then enter the data in the form of a b, if it is 1 and 1/3, then enter 1 space 1 3.

Right-click on the cell - Set the cell Gersh - Number (first item) - Select Fraction - Select the desired type - OK.

Then enter the data in the form of x y.

1. The software used in the demonstration is Excel Electronics**, and the software version is Office Home and Student Edition 2016.

2. Open the electronic **, move the mouse to the elimination bar of the upper menu, find the toolbar where the Insert Hail menu is, and find the object under the insert text.

3. Click on the object and select the equation formula input or wps formula object, and you can find the fraction and the root template source bridge scramble in the pop-up formulator, at this time we select the fraction.

4. After selecting, enter one and a third in the device, and click enter after the input is completed.

Summary. Enter 1, then space, then 1 3. This is how the fractions are entered as prescribed by Excel.

When entered in this way, the default regular cells are automatically converted to fractional format. If you convert the cells to fractional format and then enter 4 3, Excel will automatically change to 1 1 3 as well.

Excel, how to enter a fraction of 3 and 1/4.

Enter 1, then enter the space for grinding, and then enter 1 3. This mobile game Chang is the way to input scores prescribed by excel. When entered in this way, the default regular cells are automatically converted to fractional format.

If you convert the cells to fractional format first, and then enter 4 3, excel will automatically change to 1 1 3.

Enter 0, then a space, and then 2 3 for excel version reference: 2010

1. Select cell A1.

2. Enter 0 2 3

3. Press Enter to check the effect.

Note: You can't enter 2 3 directly, otherwise it will be changed to date format.

You can use the following two methods to set it up and enter it:

If the data does not participate in the subsequent calculation, it can be entered in text format, i.e.:'3/3 。

If you want to participate in the calculation, you can first set the cell format to custom: ?3 (The second method must be set according to the specific denominator, and if there are multiple data with different denominators, it cannot be set at once.) ）

can be passed".'3 3 " Note that single quotation marks are in English.

“ '3 3 " Note that single quotation marks are in English.

In Excel Help, you can see the following explanation of the entered fraction: To avoid treating the entered fraction as a date, type 0 (zero) before the fraction, such as 0 3 3.

Therefore, I have also operated in execl, 1, enter 0 in a cell first, empty a space, enter 3 3, then the number represents three-thirds, click on the cell, in the formula bar you can also see that it shows that the value of the cell is 1

Inserting mathematical special symbols will have.

1. In excel, you can enter a vertical score, such as entering 1/2, by inserting the vertical score in the formula.

2. The specific operation steps are as follows.

Insert a formula. Click on "Insert Formula Here".

Click on "Formula Tools".

Select Scores

Select "Vertical Score" and insert "1 out of 2" with the corresponding number before the vertical score

Set cells, numbers, fractions.

Then press 2 3