formula is shown instead of calculating...?
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: formula is shown instead of calculating...?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm working on a worksheet to calculate pricing, and a few of the cells with formulas don't calculate, but instead just display the entire formula. I noticed that one cell with a formula was working properly, but when I double-clicked to adjust the formula and then "entered," the formula no longer gave me the answer, but listed the formula. I can't figure out how to correct it without "un-doing" it. It is formatted as "general", and still doesn't work. (Some formulas work. cntl+~ didn't help - thanks though!)

    [ This Message was edited by: dawn on 2002-04-12 14:25 ]

    [ This Message was edited by: dawn on 2002-04-12 14:35 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The most common thing is that THAT cell is formatted as "Text". Change that to "General" (Or something else), edit the formula, press Enter, and you should see the result.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try hitting ctrl+~. It may be that show formulas is selected.

  4. #4
    New Member
    Join Date
    Jan 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dawn
    Use Edit/Clear/All, then put the formula in again.

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    This is a glitch in Excel 2000. If you formula refers to a cell which is formatted as text, it will switch your formula cell to text also. I think what you do is first format your formula cell to general (or whatever you need it to be), then hit F2 (or was it ctrl F2?). The answer is on Microsoft Support's site if that's not exactly the solution. Good luck Dawn!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com