Quote:
|
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.
|
Enter 7.87 in an empty cell
copy
select the target cell
Right click - Paste special
Check Add
OK
( I agree that is a long-winded way to do things)