1. This Board Rocks has been moved to a new domain: CarolinaPanthersForum.com

    All member accounts remain the same.

    Most of the content is here, as well. Except that the Preps Forum has been split off to its own board at: http://www.prepsforum.com

    Welcome to the new Carolina Panthers Forum!

    Dismiss Notice

Excel..help me pleasee

Discussion in 'Technology Forum' started by ville4life, Aug 15, 2006.

  1. Aug 15, 2006 at 4:57 PM #1
    ville4life

    ville4life What's the soup du jour?

    Age:
    46
    Posts:
    203
    Likes Received:
    0
    Joined:
    Jul 5, 2006
    Location:
    mo
    sometimes, when i type a formula, excel decides to display what i typed instead of the the result of the formula. or, if i have a working formula, copy it to a new cell and try to edit a cell reference or something, the formula will "stop working" and display the formula instead of the result. how the hell do i fix this? currently using office 2000, but i've had the same problem with office 03 as well.
     
  2. Aug 15, 2006 at 5:10 PM #2
    chipshot

    chipshot Full Access Member

    Age:
    50
    Posts:
    33,519
    Likes Received:
    0
    Joined:
    Feb 6, 2002
    Location:
    Boise
    make sure the cell isn't formatted as text
     
  3. Aug 15, 2006 at 6:08 PM #3
    hasbeen99

    hasbeen99 Fighting the stereotype

    Age:
    54
    Posts:
    21,242
    Likes Received:
    0
    Joined:
    Jan 7, 2003
    Location:
    Clovis, CA
    :agreed:
     
  4. Aug 15, 2006 at 9:34 PM #4
    ville4life

    ville4life What's the soup du jour?

    Age:
    46
    Posts:
    203
    Likes Received:
    0
    Joined:
    Jul 5, 2006
    Location:
    mo
    yea...first thing i did. didn't work though.. i think all the other times it has happened, it was with the same function as this time..vlookup.
     
  5. Aug 16, 2006 at 9:19 AM #5
    El Bastardo

    El Bastardo Who me?

    Age:
    58
    Posts:
    2,015
    Likes Received:
    0
    Joined:
    Jan 7, 2003
    Location:
    Ballantyne Adjacent
    Ctrl ~
     

Share This Page