Thread: How do you change the sign (e.g. +3 to -3 OR -3 to +3)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
 
Posts: n/a
Default How do you change the sign (e.g. +3 to -3 OR -3 to +3)
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)

Reply With QuoteReply With Quote