changing a range of fields

M

Mr. G.

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

Nick Hodge

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
[email protected]
 
K

Ken Wright

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.
 
M

Mr G

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
[email protected]
Click to expand...
 
Top