ADDING A NUMBER

[Helpme]

how do i add a number to a range of cells? I need to add 11.27 to a number
of different cells each with a different number in them

 

[Peo Sjoblom]

Put 11.27 in an empty cell, format it the same way as the numbers you want
to add to,
copy it, then select the numbers you want to add to and do edit>paste
special and select add.

--


Regards,


Peo Sjoblom

 

[Max]

how do i add a number to a range of cells? I need to add 11.27 to a number
of different cells each with a different number in them

Enter in a cell: 11.27
Copy that cell

Hold down CTRL and click/select all the different cells
Right-click on the selection > Paste special > Check "Add" > OK
That should do it all at one go

Clean up by clearing the cell with the "11.27" in it

 

[Gordon]

Put 11.27 in an empty cell, format it the same way as the numbers you want
to add to,
copy it, then select the numbers you want to add to and do edit>paste
special and select add.

The only problem with that method is that there is no record of what's
happened....

 

[Gordon]

Enter in a cell: 11.27
Copy that cell

Hold down CTRL and click/select all the different cells
Right-click on the selection > Paste special > Check "Add" > OK
That should do it all at one go

Clean up by clearing the cell with the "11.27" in it

No audit trail of the change. That's the problem with that method....

 

[Helpme]

Thank you that helped a bunch

Enter in a cell: 11.27
Copy that cell

Hold down CTRL and click/select all the different cells
Right-click on the selection > Paste special > Check "Add" > OK
That should do it all at one go

Clean up by clearing the cell with the "11.27" in it
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik

 

[Max]

Welcome