Put -1 in an empty cell, copy it, select the numbers and do editpaste
special and select multiply

--
Regards,

Peo Sjoblom


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