Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gary Lundblad shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    already supported  ·  Dan Battagin [MS XL] responded  · 

    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.

    Cheers,
    Dan [MS]

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base