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

Thread: Editing Reference to Text Cell

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

    Default


    When I try to edit a reference to a text cell, instead of seeing the value of the text cell, I see the literal text.

    Example: A1 (value AAA) and B1 (BBB) are text cells (in format cells, number - category), C1 contains =A1, the value AAA is shown.
    When I edit the reference, changing it to
    B1, the value =B1 is shown instead of BBB.

    Further investigation lead to this info:
    When C1 is of general format, and I edit it,
    the cell somehow looses its format but the value is shown all right. Next time I edit
    the cell, the value is not shown anymore.

    Is this a bug? A feature? What can I do about this annoying behaviour?

    Thanks for your help,
    René

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Rene,

    I had this the other night



    I popped the formulae onto a new sheet, saved and rebooted....

    not much help, huh ?!

    Chris

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
  •