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
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

Copper Contributor

Jun 22, 2021

Thanks - but it is only showing the formula for some of the cells, not all of the cells. So this is not the problem.

Riny_van_Eekelen

Platinum Contributor

Jun 22, 2021

Laura1234 Did you accidentally type an apostrophe or a space before the =-sign for the formulae that cause the problem?

Laura1234
Copper Contributor
Jun 22, 2021
No - not that either - I think maybe some of the worksheet has become corrupt?
- Riny_van_Eekelen
  Platinum Contributor
  Jun 22, 2021
  Laura1234 Can you upload it without disclosing any private or confidential information?
  - Laura1234
    Copper Contributor
    Jun 22, 2021
    How do I upload in this environment?

Forum Discussion

Cell Reference problem

Resources