Whole Numbers

[Tommy753]

In my use of formulas when calculating numbers from a live data feed. Negative numbers are important, however I am looking for a method to remove the polarity of a number and have it represented as a whole positive number regardless if it was previously negative? Can some one help?

Thanks

 

[AlKey]

you would need to use ABS function

[B]=ABS(A1)[/B]

Excel 2016 (Windows) 32 bit
	A	B
1	6546	6546
2	-456	456
3	-32165	32165
4	7899	7899
Sheet3

 

[AlKey]

Removed duplicated thread.

 

[Tommy753]

Thank you! very simple... "You don't know what you don't know" lol

 

[AlKey]

You're welcome