How to enter negative numbers in excel

How to enter negative numbers in excel?

1. Find excel on the desktop, double-click and open

2. Create a new table, name it "Negative Number Input", do Good preparation.

#3. In the excel worksheet, directly enter -20, and the displayed result is a negative number -20. The minus sign is the key to the right of the horizontal number 0 on the keyboard, which is used to input in Chinese mode.

#4. You can also enter (20) in the excel cell. Press the Enter key to display the result as a negative number.

Extended information

excel skills

1. Entering fractions in excel is relatively simple. First enter 0 in the cell, and then Type the space bar, then enter 1/2, that is, "0 1/2"

2, asterisk "*" How to find "*" is a wildcard character, if you need to find "*", press Ctrl + F keys , enter "~*" in the Find Content dialog box, that is, add "~" before the asterisk (the one above the Tab key).

3. Automatically mark failing scores. It is assumed that scores below 60 are displayed in red fonts and scores above 60 are displayed in blue fonts. Press Ctrl 1, set cell format → Customize, enter in the type input box: [blue][>=60];[red][

The above is the detailed content of How to enter negative numbers in excel. For more information, please follow other related articles on the PHP Chinese website!