Converting linked currency values into equal negatives

I

infdismd

Is it possible to link to a positive dollar amount and then have Excel
automatically convert it in my spreadsheet into its identical but negative
value?
 
D

David Biddulph

Excel uses a hyphen as a minus sign, so if your positive value is in A1, you
can use the formula =-A1
 
Top