Why is the text of my formula displaying instead of the formula result?

View comments to see user responses…

Subscribe to the FBS News E-mail ListSubscribe to the FBS News E-mail List

2 Responses to Why is the text of my formula displaying instead of the formula result?

  1. Rebecca Baggett says:

    Cells formatted as text will read formulas literally (not as formulas). The chartfield columns, and others on the template, are formatted as text by default, but can be changed to a General format to create cell reference formulas. Note that the cell will effectively inherit the format of the referenced cell, so the referenced cell should be formatted accordingly.

  2. fx says:

    What Rebecca mentioned is absolutely correct and that is the only possible reason but just to add a point, it may be possible that even if you try to format the already filled in text type cells to “General” or “Number”, you my not find any change. If that happens then you may have to just delete the values once, change the cell types and then reenter the formula.

Comments are closed.