simple query changing set of numbers from positive to negative
 

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

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

thanks for advice
"Peo Sjoblom" wrote in message
...
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