Results 1 to 13 of 13

Linked Cell Doesn't Display 00

Threaded View

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question Linked Cell Doesn't Display 00

    Hi again ya'll,

    I need the number in Cell B14 on Sheet A to be linked to Cell T25 on Sheet B. Cell B14 is custom formatted to display numbers entered as two digits. On Sheet B in Cell T25, I have a formula that reads ='Sheet A'!$B$14.

    This works swell with all two digit numbers except when Cell B14 contains 00. Now Cell T25 is empty. How do I get Cell T25 to display 00?

    Thanks!
    Last edited by swordswinger710; 12-10-2010 at 05:35 PM.

Thread Information

Users Browsing this Thread

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

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