Home |
Search |
Today's Posts |
#1
|
|||
|
|||
stop a formula from re-calculating
I have set up a spreadsheet to work out an amount to be paid, spread over 4
quarters of the year. Is there any way of stopping a cell from re-calculating without manual input of the figure? |
#2
|
|||
|
|||
Becks wrote:
I have set up a spreadsheet to work out an amount to be paid, spread over 4 quarters of the year. Is there any way of stopping a cell from re-calculating without manual input of the figure? ---------------- If you want to permanently stop it, just copy the cell and then use "paste special" "values" to paste it back over top of itself. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
formula for calculating # of days between 2 cells | Excel Worksheet Functions | |||
formula for calculating 401k if over or equal to 1 yr of service . | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Stop % showing in outcome of formula | Excel Worksheet Functions |