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

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

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

Format an empty cell as Number. Enter the number -1 in it. EditCopy. Select your numbers. EditPaste special, check Multiply

--
Kind regards,

Niek Otten

"Dave6" wrote in message ...
|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 -?

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

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


--
Gary's Student


"Dave6" wrote:

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