+ Reply to Thread
Results 1 to 3 of 3

Formula not displaying result in cell

  1. #1
    Registered User
    Join Date
    04-17-2013
    Location
    Sierra Vista, AZ
    MS-Off Ver
    Excel 2007
    Posts
    12

    Formula not displaying result in cell

    Excel is doing something I have never seen...When I type in a formula, it displays the formula itself in the cell and not the result, and yes, I am remembering the = at the beginning. When I go to the formula box to check the result, it displays the correct result with no errors. Furthermore, it seems the same formula displays correctly in some cells an not others. When I cut and paste the same formula into the same cell, most of the time, it reverts back to showing the formula and not the result. I've tried it from different documents and different computers! Anyone ever seen this before? and is there a way to correct the issue?

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Formula not displaying result in cell

    hi Nolander01, welcome to the forum. it's very possible the cell is a Text. press CTRL + SHIFT + ~ to convert it to General. then press F2 in the cell & ENTER. if you have many cells to convert, select the range & go to Data -> Text to columns -> Next -> Next -> Finish

    if it doesnt help, attach a sample excel file for us to see.
    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    04-17-2013
    Location
    Sierra Vista, AZ
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Formula not displaying result in cell

    Originally, I did check the formatting in the cell box to make sure it was set to general, and it was. Nevertheless, your suggestion still worked to fix the issue. Thanks so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1