![]() |
|
#1
|
|||
|
|||
![]()
Hi,
This may sound simple but how do you format a Cell so that when you add an additional figure it is added to the one already there,for example a row containing a cell for miscellaneous items which can not be summed with anything else. ie cell contains the figure £23.89 and i want to ad £7.87 to this,is there a way to just highlight the existing figure/cell,type the additional amount and let excel do the calculation.At the moment i am doing the calculation manually and adding the result to the cell. Hope this makes sense Mark |
#2
|
||||
|
||||
![]() Quote:
copy select the target cell Right click - Paste special Check Add OK ( I agree that is a long-winded way to do things) |
#3
|
||||
|
||||
![]()
Alternatively, so that you can continue to see the component parts of the cell value in the formula bar, simply insert a '=' sign before the first # (you might even make this a habit for the initial data entry), then insert a '+' sign followed by the second value. You can keep inserting '+' (or '-') signs followed by values as required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
UnholySmoke | Excel | 2 | 09-14-2011 08:15 AM |
![]() |
Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
![]() |
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |