I have a column that contains both positive and negative numbers. The Find or Find/Replace function doesn’t appear able to identify the minus symbol. My searches and resulting solutions found on this site either don’t work or provide insufficient information.
Can anyone provide or point me to a way to identify those cells in a column which contain negative numbers, i.e. which are using the minus symbol?
Thanks
Hi
The Find & Replace function allows you to find the negative values.
You do not say what to replace the negative values. If I assume, for example, that you only want to remove the minus sign and keep the value, you can do this:
-
Regards
Also, if the numbers in that column are the result of a calculation and you want all the results to be positive numbers, that is, changing any negative numbers into corresponding positive numbers, you could enclose the original formula in the ABS (absolute) function :
=ABS( x+y-z whatever )