How to Change Negative Numbers to Positive in Excel
This post will guide you how to change all negative numbers to positive in Excel 2013/2016. How do I remove negative sign to a number in cells with a formula in Excel.
- Change Negative Numbers to Positive with a Formula
- Change Negative Numbers to Positive with Find and Replace function
Table of Contents
Change Negative Numbers to Positive with a Formula
Assuming that you have a list of data in range B1:B5, in which contain numeric values. And you want to convert all negative numbers to positive. How to do it. You can use an Excel formula based on the ABS function to achieve the result. Here is the formula that you can use it.
=ABS(B1)
Type this formula into a blank cell and press Enter key on your keyboard, and then copy this formula from Cell C1 to range C2:C5 to apply this formula.
Change Negative Numbers to Positive with Find and Replace function
You can also use the Find and Replace command to achieve the same result of changing negative numbers to positive in Excel. Here are the steps:
#1 select the range that you want to convert negative numbers to positive.
#2 go to HOME tab, click Find & Select command under Editing group. And select Replace from the drop down menu list. And the Find and Replace dialog will open.
#3 type the negative sign in the Find what text box, and keep blank in the Replace with text box.
#4 Click Replace All button in the Find and Replace dialog box. You would notice that all negative signs have been removed in the selected range of cells.
Related Functions
-
Excel ABS Function
The Excel ABS function returns the absolute value of a number.The ABS function is a build-in function in Microsoft Excel and it is categorized as a Math and Trigonometry Function.The syntax of the ABS function is as below:=ABS (number)…
This post will guide you how to use Excel RRI function with syntax and examples in Microsoft excel. Description The Excel RRI function Returns an equivalent interest rate for the growth of an investment. So you can use the RRI ...
CAGR in Excel is a formula that calculates the compound annual growth rate for any invested amount over the specified years or timeframe. Although there is no direct function in Excel that can help us identify the CAGR value, there ...
You might have come across a task in which you were assigned to build hyperlinks, which seems very easy, and if you are new to excel or don't have enough experience with it, then you might wonder about doing this ...
Suppose you got a task to adjust the values that contain the ties; what would be your first attempt to break the ties of the given value? If you are wondering about doing this task manually, let me add that ...
In today's article we will show you how to calculate the total cost for a given weight using the Excel VLOOKUP function. This function will help us to find the appropriate unit price for that weight and then we can ...
Assume that you've been assigned a task of calculating bond valuation; so if you are new to Ms Excel or do not have much experience with it, then I am pretty sure about it that doing this task manually might ...
Today, through a simple example, we will show you how to use one of the most common-used Mathematical functions in excel, the SUM function, to add up the sum. In our daily life, we keep an account of what we ...
You might have come across a task in which you were assigned to make BMI calculations of the supplied numbers, and you may be looking for an efficient approach to accomplish this process rather than doing BMI calculations manually, by ...
In our daily life, most of us will invest or take a loan, so we need to master some simple financial functions to calculate the period needed for loans or investments. If you work as an accountant, you need to ...
In the office, a special machine record the time when you start working (clock in office) and when you finish working (clock out of office). We can calculate the total working time by subtracting the end working time from the ...
