How to write semicolon in excel

1. Punctuation in Chinese"; This can be typed directly, to the right of the "L" key;

Second, the line in the middle of the fraction in mathematics, this is not called "semicolon", its name is "fraction line", "fraction line" in excel is replaced by the division sign of excel, that is, " ", such as "quarter" written "1 4", the following is an introduction to the input method of this fraction:

Excel recognized fraction "1 4" format, directly enter "1 4", if it is "one and a quarter", enter "1 1 4", integers and fractions are separated by a space.

Advantages: Can participate in number crunching. Disadvantages: It does not conform to our conventional way of writing, and it is awkward to look at the advantages (just look at the habit);

Let this score be close to our writing form" "This will appear if you use the Sogou input method to type "sifenzhiyi".

Advantages: The form is close to the conventional way of writing and easy to type. Disadvantages: It is a text and cannot be calculated;

Let it fit perfectly into our writing form and become a complete upper and lower structure:

Click on the "Formula" button on the "Insert" tab.

Click the Fraction drop-down arrow and select the first style.

In the box that appears, enter 1 at the top and 4 at the bottom

Just move it to where you need it.

If you think this is too troublesome, look at the following figure, you can understand at a glance, merge several cells, the cell where the fraction is written only adds the border line in the middle, and the font is smaller than the other cells.

Advantages: The shape meets the requirements. Disadvantages: It still can't be calculated, and the position is not easy to move.

You can use two lines. The two lines are separated for input. The other cells are merged into one box.

Tools Materials: Computer, Excel.

The first step is to open the scramble slide brain and open the corresponding software to enter the interface.

The second step is to open the corresponding document after entering the interface.

The third step is to find the insert click of the hidden scramble bar in the upper menu.

Step 4: Find the symbol in the upper menu bar and click on it.

Step 5, pop-up window, select the font"lucida sans unicode"Subset "Generalized Punctuation", find the seminator and click to insert.

The electronic ** can only enter 1 4, the semicolon is oblique, and the format under the denominator cannot be directly entered on the numerator.

Switch to the Chinese input method first, and then enter.

It may be the reason for your input method.,Try a different software method.。

It's okay to just enter the semicolon, how can you not lose?