If you want to get the result of a negative value, you have to use the ABS function. The ABS function returns the absolute value of a number; it converts negative numbers to positive numbers ...

Learn how to highlight cells with negative values in Excel. Make negative numbers stand out in Red using Conditional or Custom Formatting.

This is particularly handy when working with financial data or any dataset that includes negative numbers. To convert negative values to positive: ...

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.