Excel Quickie 18 - Convert All Negative Values to Positive Values in Excel

Описание: Excel File: https://www.teachexcel.com/excel-tuto...

Excel Quickie 17:    • Excel Quickie 17 - Protect Only Specific C...  
Excel Quickie 19:    • Excel Quickie 19 - Store Huge Numbers the ...  

Two simple and effective ways to quickly convert negative numbers to positive numbers in Excel.

These methods work well on single cells or entire data sets. This tutorial includes multiple methods for getting positive values from a list, one that works only on negative values and one that works for lists that have both negative and positive values in them.

As well, I'll show you how to quickly convert all values output by a formula into their visible values.

Enjoy!

TeachExcel.com