Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to retrieve first match between two ranges in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • To count total rows in a range in Excel
  • Get nth match with INDEX / MATCH in Excel

Data Analysis Examples

  • Excel Line Chart
  • How To Create Frequency Distribution in Excel
  • Example of COUNTIFS with variable table column in Excel
  • Randomize/ Shuffle List in Excel
  • Conditional Formatting New Rule with Formulas in Excel

Data Validation Examples

  • Excel Data validation require unique number
  • Prevent invalid data entering in specific cells
  • Excel Data validation date in next 30 days
  • Excel Data validation with conditional list
  • Excel Data validation only dates between

Change negative numbers to positive in Excel

by

To change negative numbers to positive and leave positive numbers along (i.e. get absolute values) use the built-in ABS function. See illustration below:

Formula

=ABS(number)

Explanation

In the example shown the formula in C6 is:

=ABS(B6)

How this formula works

The ABS function is fully automatic. All you need to do is supply a number and ABS will return the absolute value.

Worked Example:   Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions

Convert negative numbers in place

If you only need to convert negative numbers once, you can convert in-place with Paste Special:

  1. Add -1 to a cell and copy to the clipboard
  2. Select the negative numbers you want to convert
  3. Use Paste Special > Values + Multiply

Post navigation

Previous Post:

Cash denomination calculator in Excel

Next Post:

Convert feet and inches to inches in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove text by variable position in a cell in Excel
  • MID, MIDB functions: Description, Usage, Syntax, Examples and Explanation
  • How to extract name from email address in Excel
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • How to count specific characters in a cell in Excel
  • Get week number from date in Excel
  • How to calculate working days left in month in Excel
  • Get days, months, and years between dates in Excel
  • Get work hours between dates and times in Excel
  • Get days between dates ignoring years in Excel
  • ACCRINTM function: Description, Usage, Syntax, Examples and Explanation
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYS function: Description, Usage, Syntax, Examples and Explanation
  • How to set check register balance in Excel
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles