Simple formula fix
The cells are formatted as Text. You need to format them back to general (Format >> Format Cells) and then click into the formula bar for each formula and then hit enter. This will refresh them and excel will now see them as formulas.
|