Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING A NUMBER
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING A NUMBER
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 editpaste special and select add. -- Regards, Peo Sjoblom "Helpme" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING A NUMBER
"Helpme" wrote:
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING A NUMBER
"Peo Sjoblom" wrote in message
... 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 editpaste special and select add. The only problem with that method is that there is no record of what's happened.... |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING A NUMBER
"Max" wrote in message
... "Helpme" wrote: 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 No audit trail of the change. That's the problem with that method.... |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING A NUMBER
Thank you that helped a bunch
"Max" wrote: "Helpme" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
ADDING A NUMBER
Welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Helpme" wrote in message ... Thank you that helped a bunch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding number within a cell | Excel Worksheet Functions | |||
Adding a number to a cell that already has a number. | Excel Discussion (Misc queries) | |||
Adding a Number value to Time | Excel Worksheet Functions | |||
adding digits of a number | Excel Worksheet Functions | |||
Adding A Set Number Once a Week? | Excel Worksheet Functions |