Fix problem where formulas display rather than their results, when this option has not been selected.
Every now and then a formula displays rather than the result of the formula. I realize there is an option for this; however; on occasion it happens to a particular cell or range of cells when this option has not been selected. The rest of the worksheet functions properly. This has been an ongoing problem for years.
Hi, This happens when a cell is formatted as Text prior to entering a formula. Since formatting a cell as text is an explicit operation, Excel doesn’t “automatically change that formatting” when you enter a formula.