How do I change a range of values from + to -?

D

Dave6

I have a large range of values representing a floor elevation survey that I
will produce a 3D graph with. I need to change all the values in the range
from + values to - values to represent dips in the floor, not high spots. How
do I change the whole range of values from + to -?
 
N

Niek Otten

Format an empty cell as Number. Enter the number -1 in it. Edit>Copy. Select your numbers. Edit>Paste special, check Multiply

--
Kind regards,

Niek Otten

|I have a large range of values representing a floor elevation survey that I
| will produce a 3D graph with. I need to change all the values in the range
| from + values to - values to represent dips in the floor, not high spots. How
| do I change the whole range of values from + to -?
 
G

Gary''s Student

In an un-used cell enter -1
copy that cell
select the cells you wish to invert
pull-down:

Edit > PasteSpecial... > check the multiply box
 
Top