Forum Discussion

Laura1234's avatar
Laura1234
Copper Contributor
Jun 22, 2021
Solved

Cell Reference problem

I have referenced a cell to another cell in the same page or in another tab in the workbook, and the cell is formatted to TEXT but I am not getting what is in the referenced cell - I am getting the f...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 22, 2021

    Laura1234 I noticed two cells in the Expenditure sheet (A27 and A51). These contain formula like entries but are displayed as texts. As I mentioned earlier, you must have entered the formula after the cells were formatted as text. To fix the problem, select A27, format at General, click in the formula bar and then Enter to re-confirm the entry of the formula. Now you'll have a working formula. Repeat for A51. Cell A27 will display 0 (zero) as it refers to an empty cell. A51 will display 2000. If there are more cells like this, I trust you can find and fix them yourself.

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 22, 2021

Laura1234 I noticed two cells in the Expenditure sheet (A27 and A51). These contain formula like entries but are displayed as texts. As I mentioned earlier, you must have entered the formula after the cells were formatted as text. To fix the problem, select A27, format at General, click in the formula bar and then Enter to re-confirm the entry of the formula. Now you'll have a working formula. Repeat for A51. Cell A27 will display 0 (zero) as it refers to an empty cell. A51 will display 2000. If there are more cells like this, I trust you can find and fix them yourself.

 

  • Laura1234's avatar
    Laura1234
    Copper Contributor
    Jun 22, 2021
    Ahhhh - fixed! thank-you very much!

Resources