simple query changing set of numbers from positive to negative

S

sammy

have a string of numbers in a column that are positive and would like to
make negative

ie

1384.40
128.31
193.7
....
and would like to make place minus in front
ie

-1384.40
-128.31
-193.7
....

Appreciate advice
Sammy
 
P

Peo Sjoblom

Put -1 in an empty cell, copy it, select the numbers and do edit>paste
special and select multiply
 
Top