Displaying Formulas in Cells
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Displaying Formulas in Cells

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    This should be easy. I am fairly new to the ability of excel, been using it for way too long not to know its power. Anyways, this forum has been a great help, kudos.
    My problem is, I have a sheet in which i poulated with information form another workbook in this form.
    =[logs.xls]salesloghidden!R2C3
    I do this for about 20 cells in different areas of the sheet.
    Half of the time the cell displays the correct information, the other half it displays THE FORMULA. I think I have tried everything, even if I put =a3 in one of these cells it displays =a3. What gives. What is the little detail I am missing.
    Thanks in advance.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The cells that are showing the formula are formatted as text. You may need to select those rows/columns/cell, hit Edit-clear-formatting or All. Then re-enter the formula if necessary.


    ~Anne Troy

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    [ This Message was edited by: d-alan on 2002-03-27 08:04 ]

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    [ This Message was edited by: d-alan on 2002-03-27 08:05 ]

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    It is all working now. It was the format issue, I formatted all problematic cells to general and now it is ok.
    Thanks for your help.

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