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