changing a range of fields
 

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?

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?

Put -1 in a cell. Copy the cell, select all your data to be changed and do
Edit / Paste Special / Values & Multiply. Delete the -1.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"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?

Thank you very much

"Nick Hodge" wrote:

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?