Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking to cells with text (Excel 2000)

    Here is an annoying little problem:
    when creating a link to a cell that may (or may not) contain text. The linked cell will display 0 if the content of the cell was deleted. I don't like that - so instead, I'm using an if function:
    if(linkedcell=0,"",linkedcell)
    This seems more complicated than it should be. Am I overlooking a formatting option?

    TIA

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to cells with text (Excel 2000)

    You are doing what I would do. However, there are a couple of other options. You can create a custom cell format to not display zero values. You can also go to Options in the Tools menu and then click on the View tab. In the Windows options section remove the check mark from next to "Zero values." Or you can use a formula like this: =A1&""
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to cells with text (Excel 2000)

    what custom text format would suppress zeroes?

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to cells with text (Excel 2000)

    #,##0;-#,##0;""
    Legare Coleman

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Linking to cells with text (Excel 2000)

    Try,

    0;-0;"" replacing the zeros with your preferred number format. The third item, in this case "", determines how zeros are displayed.

    Andrew C

  6. #6
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to cells with text (Excel 2000)

    Thanks guys!

Posting Permissions

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