changing a range of fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Edit>Paste special...>Values over the existing data to
replace it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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.
 
Thank you very much

Nick Hodge said:
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 Edit>Paste special...>Values over the existing data to
replace it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Click to expand...
 
Back
Top