Video Source (06:49 mins) | Transcript

**Typing Negative Numbers**

Negative numbers are typed into Excel by using a hyphen - symbol and the number.

Example: negative 3 is typed “-3” without the quotation marks.

**Cell Formatting**

In this course we will always show negative numbers as black numbers with a negative symbol in front of them, however, there are other ways to display negative numbers in Excel. Some of these other notations are used in accounting, bookkeeping, and finance.

Cells can be formatted so that negative numbers display differently.

Go to the **Format Cell** window by right-clicking the cell you want to format.

Under the **Number** tab, select the **Number** or **Currency** category.

In the **Number **category you will see four options for negative numbers:

- -1234.10 = This option keeps negative numbers black with a negative symbol in front.
- 1234.10 = This option turns negative numbers typed into these cells red without a negative symbol.
- (1234.10) = This option keeps the negative number black but displays them with parentheses around them. This notation is often used in accounting and bookkeeping.
- (1234.10) = This option turns negative numbers red and displays them with parentheses around them.

In the **Currency **category, the options are the same except they are also displayed with a currency symbol.

For this class and in general, we recommend using the standard - hyphen to show a number is negative.

**Arithmetic with Negative Numbers**

The arithmetic on negative numbers is the same as on positive numbers in Excel.

You can reference cells with negative numbers just as you would positive numbers. You can also write equations with negative numbers.

Example: Type “-3*-5+-1” into a cell. Press **Enter**. You should see the number 14 appear in the cell because \( (-3)(-5) + (-1) = 15 +(-1) = 14 \) and \(15 + -1 = 14\).

**NOTE:** You may want to use parentheses in examples like this to make them more readable. Excel will follow the order of operation.

## Need More Help?

- Study other Math Lessons in the Resource Center.
- Visit the Online Tutoring Resources in the Resource Center.
- Contact your Instructor.
- If you still need help, Schedule a Tutor.