Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Weird !!

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    ENGLAND
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It may be a bug in my copy, but sometimes in excel I reference a cell in the normal way e.g. in cell a1 i type =f11 and the value gives me whatever is in f11. OK correct.
    If I then change that to =f12 it just says =f12 in the cell !!! If I change it back to =f11 it now says =f11. No matter what I try it doesn't go back to just showing the value of the referenced cell.

    Anybody experienced the same?!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    United Kingdom
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you accidentally inserted a ' in the cell before the = sign? This would force the cell to treat your entry as text rather than a function, which is what it seems to be doing.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    ENGLAND
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No thats what i first thought,
    When you F2 it does show a ' but if you delete this it still gives the same result.
    On the S/Sheet I'm in at the moment it even does it when you press f4 to put the "$" signs in. e.g =a1 gives a value of 2, press f4 and it shows =$a$1 ???????

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Sheffield, UK
    Posts
    253
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you formatted the cell to text? Go into format - cell and change it to "general". You will then have to remove the ' from in front. Hope this is it, or it really is weird!

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    ENGLAND
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Cheers Phil,

    Thats sorted it. I'm going to blame it on the person who set the original sheet up. Wasn't me - Honest

Some videos you may like

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
  •