I am updating a workbook a colleague had handed off to me. There are several sections that contain formulas that pull data from other cells (some of these are simple calculations that sum two cells, others are more complicated formulas). These formulas appeared to be working until I double clicked one formula to view its inputs, then hit enter. The result, which was a value >0 before, turned to 0.

This occurs throughout the time series.

I tried F2 + ctrl/shift/enter, but I still get 0's as a "new" result, even though the inputs have not changed.

Any ideas?

Thanks in advance for your help!