• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

2 Simple ways to convert negative numbers to positive in Excel 

0 Comments

2 Simple ways to convert negative numbers to positive in Excel: Table of Contents: Display Converting negative numbers to positive or vice versa in Excel is a common issue that many people encounter. If the data table is small, you can manually edit it by removing the negative sign from each set of numbers. However, if the data volume is large, this will be a tricky problem if you don’t know how to do it. Follow the article below to learn how to convert negative numbers to positive in Excel.

1. Use Paste Special to convert negative numbers to positive

For example, if you need to convert negative numbers in the table below to positive numbers. First, you enter -1 in any cell on the worksheet. Then, press Ctrl + C to copy that cell.

2 Simple ways to convert negative numbers to positive in Excel 

2 Simple ways to convert negative numbers to positive in Excel

Next, select all the cells that you want to convert from negative to positive, then right-click and select Paste Special.

2 Simple ways to convert negative numbers to positive in Excel 

2 Simple ways to convert negative numbers to positive in Excel

At this point, the Paste Special window appears. You tick the Multiply option and press OK to complete.

2 Simple ways to convert negative numbers to positive in Excel 

2 Simple ways to convert negative numbers to positive in Excel

That’s it, the selected negative numbers have been quickly converted to positive numbers.

2 Simple ways to convert negative numbers to positive in Excel 

2 Simple ways to convert negative numbers to positive in Excel

2. Convert negative numbers to positive using the IF function

For example, you have a data table as shown below. It contains both negative and positive numbers, and you need to convert all numbers to positive.

2 Simple ways to convert negative numbers to positive in Excel 

2 Simple ways to convert negative numbers to positive in Excel

First, enter -1 in any cell on the worksheet. Then, in cell D2, enter the formula:

=IF(C2<0;C2*$E$1;C2)

Copy the above formula for all cells below, and you will get the results as shown below:

2 Simple ways to convert negative numbers to positive in Excel 

2 Simple ways to convert negative numbers to positive in Excel

Next, select all the results you just got, then press Ctrl + C to copy. Then right-click on the first cell of the original negative number column and select the Paste Value icon. All negative numbers in the column have been converted to positive numbers.

2 Simple ways to convert negative numbers to positive in Excel 

2 Simple ways to convert negative numbers to positive in Excel

That’s it, the above article has shown you how to convert negative numbers to positive in Excel. Hope this article will be helpful to you in your work. Good luck!

Rate this post
46
304 Views
What Is Macro In Excel? How To Use Macro In Excel?PrevWhat Is Macro In Excel? How To Use Macro In Excel?April 6, 2023
How to retrieve deleted/overwritten sheet in ExcelApril 6, 2023How to retrieve deleted/overwritten sheet in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
  • Buy Windows 11 Professional MS Products CD Key Buy Windows 11 Professional MS Products CD Key
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 1 Device 1 Year Global AVG Internet Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Buy Office 2021 Professional Plus Key Global For 5 PC Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $68.00
  • Avast SecureLine VPN 2021 2 Years 5 Devices Global Avast SecureLine VPN 2021 2 Years 5 Devices Global
    Rated 5.00 out of 5
    $47.00
Products
  • Project Professional 2021 Microsoft Project Professional 2021 - 1 PC $13.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • Windows 10 Enterprise LTSC 2019 Key Global Windows 10 Enterprise LTSC 2019 Key Global
    Rated 4.83 out of 5
    $9.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
  • Microsoft Visual Studio Enterprise 2019 For 1 PC Microsoft Visual Studio Enterprise 2019 For 1 PC
    Rated 4.88 out of 5
    $15.00
  • Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 15 PCs + 15 Mobiles + 2 Servers 1 Year
    Rated 5.00 out of 5
    $201.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.