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

[Guest]

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 -?

 

[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 -?

 

[Guest]

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