I have a spread sheet sent to me by a friend and I want to add a column with some formulas in. Instead of containing the results of the formulas the new cells contain the text of the formula. Why? How do I fix this?
Here's a simple example in which I would expect the cell B1 to contain the text
Tim but instead it contains the text