Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






Multiple Using Paste Special to convert Negative Figure into Positive In Excel

Convert Negative Number into Positive Number tutorial

Tutorial in brief

Let’s think about a different situation where instead of getting positive numbers in a different column you need them in the same column.

And for this, you can use the paste special option. Wondering how? Let me tell you. In paste special option, there are “operation” options which you can use to perform some simple calculations. You can use these same options to make negative numbers positive without using any formula or adding any extra column. Just follow these steps.

negative number into positive with paste special

  • First of all, in any cell in your worksheet, enter -1.
  • After that, copy it.
  • Now, select the range of cells in which you have negative numbers.
  • Right-Click ➜ Paste Special ➜ Operations ➜ Multiply.
  • In the end, click OK.

Now, all the negative numbers are converted into positive.

The only thing you need to take care of is that this is not a dynamic method. So, you need to do it again and again if you frequently update your data. But this method is quick and easy to use, and you don’t need any formula.

Other Methods to convert Negative Number into Positive

Choose the tutorial that fits best for your case –

  1. Multiply with Minus One to Convert a Positive Number in Excel
  2. How to convert to an Absolute Number with ABS Function in Excel ?
  3. Multiple Using Paste Special to convert Negative Figure into Positive In Excel
  4. How to Remove Negative Sign with Flash Fill in Excel ?
  5. How to apply Custom Formatting to Show as Positive Numbers in Excel ?
  6. How to run a VBA Code to Convert to Positive Numbers in Excel ?
  7. How to Use Power Query to Convert Get Positive Numbers ?
Content

Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes