One way, type -1 in an unused cell, copy it, select the range to change and
right-click->Paste Special and choose multiply, this will multiply everything
by -1 thus converting your signs.
Just multiply each cell by -1. A quick way to do this is to enter -1
into a blank cell somewhere and to <copy> that cell. Then highlight
all the cells whose values you want to change and click on Edit |
Paste Specal | Values (check) | Multiply (check) | OK then <Esc>. Then
you can delete the -1 from the first cell.
Hope this helps.
Pete
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.