Thread: How do you change the sign (e.g. +3 to -3 OR -3 to +3)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
Ron Rosenfeld
 
Posts: n/a
Default How do you change the sign (e.g. +3 to -3 OR -3 to +3)
On 15 Nov 2005 10:59:31 -0800, wrote:

I need to know how to automatically change the sign of a number (it
could be either positive or negative)

Please could someone tell me how to do this


(this is such a simple thing but I can't figure it out)


multiply by -1


--ron
Reply With QuoteReply With Quote