changing sign

[simora]

How do I change a value using either a formula or Macro
etc.. so that positive values become negative values when
sent to another cell for calculations

 

[Nick Hodge]

If you have 100 in A1 and you want -100 in B1 try

=-A1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

 

[simora]

Got it.

Thanks
..............................