put -1 in an empty cell
edit|copy (that cell)
select your range to fix
edit|paste special|check multiply
clean up that cell with -1 in it.

" wrote:

Hi Folks

Am using Excel 2002.

I have a column of data like this:
5, 16, 27, 38, 39

Is it a fast and automatic way of turning all these into negative....
that reads
-5, -16, -27, -38, -39

Thanks!

--

Dave Peterson