The simplest method would be to insert a column, and for each entry
write a formula: =0-A1 (where A1 is the positive number- replace A1
with your actual cell reference). Then copy the inserted column,
highlight your original column, and Paste As values. Then delete the
column you inserted.
|