Thread: change a positive number to negative
View Single Post
  #16  
Old November 12th, 2009, 06:17 PM posted to microsoft.public.excel.misc
MICHALK
external usenet poster
  
Posts: 10
Default change a positive number to negative


"Pete_UK" wrote:

Try this:

=MIN(A1,-A1)

This will keep negative numbers and turn positive numbers to negative.

Hope this helps.

Pete

On Nov 12, 5:07 pm, MICHALK wrote:
How to change a positive number to negative?

.
Thanks, but was wanting something faster....want values only.