Formulas

[MetLife]

Hi,

Excel isn't working. It isn't calculating basic calculations. When I type in the formula in cell A1 = "C23" it does not show the result for cell C23, it just shows the formula itself. "=C23"

How do I fix this?

Thanks

 

[Joe4]

That means that you have your cell formatted as "Text", which means it will show literally whatever you have typed in there (and not do any formula evaluations).
Change the format of the cell to "General" and re-enter the formula and it will work.

 

[MetLife]

Yup that was the problem! Thanks