How do I prefix a worksheet of numbers with a Minus (-) Sign
Put -1 in a spare cell (on that sheet or another one), select and copy it,
then select your range of positive numbers, Edit, Paste Special/ Multiply.
--
David Biddulph
"Sammy" wrote in message
...
I have a whole worksheet full of positive numbers and would like to reverse
them to negative numbers without having to retype them in. Would anyone
know
a shortcut whereby i would be able to prefix all the numbers with minus
sign?
Many thanks
|