I have a formula in a cell. it works fine, and then i need to modify something inthe formula and now the formula is displayed as a text. Originally, the formula (=Budget!$B$72) was hidden, now after making a slight change (=Budget!B$72), it is displaying the formula in the cell =Budget!B$72 as a text. can anyone help me with this thanks.

Actually, all i need to do is put the cursor into the formula and hit enter, and the formula is displayed without any changes.