• 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
308 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
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.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
  • 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
Products
  • Visio Professional 2024 Visio Professional 2024 $33.00
  • Project Professional 2013 Microsoft Project Professional 2013 - 1 PC $9.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
  • Microsoft Office 2019 Home and Student for PC Key Global bind to your Microsoft account Microsoft Office 2019 Home and Student for PC Key Global bind to your Microsoft account
    Rated 4.95 out of 5
    $58.00
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows Server 2025 Remote Desktop Services 50 Device Connections Windows Server 2025 Remote Desktop Services 50 Device Connections $25.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
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.