View comments to see user responses…
Categories
-
Recent Posts
- Participate in the e-Journal Excel Users Forum
- How can I modify my formula to return a blank instead of 0?
- Why is the text of my formula displaying instead of the formula result?
- Why can’t I paste data into the template?
- Is there a way to auto-delete rows in my template that have no amount specified?
-
Recent Comments
- fx on Why is the text of my formula displaying instead of the formula result?
- Rebecca Baggett on Why can’t I paste data into the template?
- Rebecca Baggett on Why is the text of my formula displaying instead of the formula result?
- Rebecca Baggett on How can I modify my formula to return a blank instead of 0?
- Jacob Hintze on Is there a way to auto-delete rows in my template that have no amount specified?
Archives
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.
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.