• 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
49
319 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 Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
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
  • Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global Windows Server 2012 Remote Desktop Services 50 USER Connections Key Global
    Rated 4.69 out of 5
    $25.00
  • Avast Premium Security 2021 10 Devices 2 Years Global Avast Premium Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $41.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 Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Windows 10 Pro Key Global 20 PC Windows 10 Pro Key Global 20 PC $50.00
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • SQL Server 2014 Standard SQL Server 2014 Standard $20.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
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.