+ Reply to Thread
Results 1 to 12 of 12

Cell linking displayed in text

  1. #1
    Registered User
    Join Date
    09-17-2009
    Location
    Oklahoma, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Cell linking displayed in text

    I am trying to have a cell in a diffrent work sheet display information from another sheet.

    I entered ='Weapons Table'!A48 and it is displaying in text not what is actually in that cell.
    on the cell above it I have entered ='Weapons Table'!A47 and it displays fine.

    I've tried typing = then just clicking the cell, and it is still just displaying it as text. I've spent 3 days on this sheet and have only 1 error, that is driving me crazy.

    I'm on excel 2007 and have exhausted all my collegues who have any excel expertise. please help.
    Last edited by beefree; 09-21-2009 at 05:06 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Cell linking displayed in text

    What does this mean:

    it is still just displaying it as text
    you see the formula and not the result, or a number displayed as text?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Cell linking displayed in text

    what is in the original cell?
    what exactly is displaying in the cell referencing it?
    have you checked the cell's format and set it to the one you want?

    Maybe post a workbook, so we can have a look at the actual data?

  4. #4
    Registered User
    Join Date
    09-17-2009
    Location
    Oklahoma, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cell linking displayed in text

    when I type = then click the cell I want it to display it will automatically type in what sheet and cell it is but it will display for example ='Weapons Table'!A48 instead of the value in that cell.

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Cell linking displayed in text

    Try to do an edit|replace of = with =

  6. #6
    Registered User
    Join Date
    09-17-2009
    Location
    Oklahoma, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cell linking displayed in text

    I attached a stripped copy. as you can see in the 2nd sheet on the 27th row its just not displaying right.

    and my ceiling just started leaking!
    Attached Files Attached Files

  7. #7
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Cell linking displayed in text

    See my last reply...

    And replace = with = and click Replace All.

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Cell linking displayed in text

    You can also select each column independently, starting from row 9 down.. and then go to Data|Text to columns and simply click Finish... repeat for each column from row 9 down...

  9. #9
    Registered User
    Join Date
    09-17-2009
    Location
    Oklahoma, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cell linking displayed in text

    I dont understand "replace = with =" could you explain to a dummy real quick?

  10. #10
    Registered User
    Join Date
    09-17-2009
    Location
    Oklahoma, USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cell linking displayed in text

    Nevermind I get the text to column. Thanks for the help. now, do you know any good plumbers in Sounthern Oklahoma?

  11. #11
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Cell linking displayed in text

    In the Home Tab, go the Find/Replace icon (binoculars) and choose Replace.

    Enter = sign in both fields.

    Click Replace All.

  12. #12
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Cell linking displayed in text

    Quote Originally Posted by beefree View Post
    Nevermind I get the text to column. Thanks for the help. now, do you know any good plumbers in Sounthern Oklahoma?
    I live in Canada... so no, sorry.. good luck with that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1