Thanks ALIGW.

Cell A1 contains the result of a formula, the answer to which is 987. If I were to copy cell A1 to cell B5 and paste values, I will get the value 987 in cell B5 not the result of the formula. So, can I define cell B5 in such a way that it contains the contents of cell A1, but as value 987, not the formula.