Hi,
Who can tel me how i can prefent a cel for recalculation. In a ceel i'f put the formule =NoW(). The result off te cell depents on the content of a different cell. If the different cell > 0 the the time appears. But.. in the next collum i use the same formule. By filling the "different" in this collum the light time appears in this column ut even in the first column. How can i prefent that??
Thnx for any good reaction.
Siepos
Holland
iMac, Mac OS X (10.6.8)
place the formula:
=now()
in another cell where you can select the cell conveniently. select the cell, copy
now paste in the destination using the menu item "Edit > Paste Formula Results"
There is no way to prevent a cell with a formula from updating.
place the formula:
=now()
in another cell where you can select the cell conveniently. select the cell, copy
now paste in the destination using the menu item "Edit > Paste Formula Results"
There is no way to prevent a cell with a formula from updating.
Hi Wayne,
Thank you very much for your help. It was very usefull.
Siepos
Holland
prefent a cel for recalculation
