Mr G

You can use another cell, so if you have 100 in A1 and in A2 enter

=-A1

It will show -100. You can then copy this down as far as the data goes and
then copy it and EditPaste special...Values over the existing data to
replace it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Mr. G." <Mr. wrote in message
...
I have a range of fields that needs to be changed from a posivtive number
to
a negetive number, how do I changed a range of fields at a time?