Excel change negative to positive and vice versa

This effortless Excel tutorial shall show you how to make numbers negative in Excel step by step with real worksheet images.

It’s often necessary to input negative numbers in Microsoft Excel for financial analysis, data manipulation, error handling, and mathematical operations.

How to put a negative number in excel without formula

The conventional wisdom says you type the subtraction operator (the minus sign) followed by a value. However, this method is pretty basic and highly time-consuming.

I’ve gathered below all the intuitive and automated methods to convert positive numbers to negative in Excel.

Let’s get started!

Make Numbers Negative Using Flash Fill

Suppose, you’ve got a column (column A) filled with positive numbers that need conversion into negative numbers.

Go to the adjacent column and select the first cell.

There, enter the following formula and hit :

Now, select the first cell with a negative number and drag the fill handle down the column to fill the rest of the cells with negative numbers of the corresponding cells in column A.

how to show minus value in excel

how to show negative numbers in excel formula