Editing Reference to Text Cell
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

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