I am having a very strange problem with two spreadsheets that I hope someone can help me find the solution to.

What I have is two spreadsheets that each have cells with formulas to display the values in other related spreadsheets. All of the current cells are displaying properly, but now that I'm trying to add cells pointing to other cells in these same spreadsheets, instead of the values displaying in the cell, all I'm getting is the actual formula displaying in the cell.

I've tried copying the formatting of a working cell to the new cell, copying currently working formulas into the new cell and just altering the cell it's supposed to point to, but nothing seems to work.

I've looked into the options of the spreadsheets, and nothing seems amiss (not to mention that there are cells that are working just fine)

I'm baffled. Can anyone help

Thanks