General discussion

  • Creator
    Topic
  • #2297768

    Cell format

    Locked

    by rtb.eng ·

    I am linking one cell, in an Excel (2000) sheet to another cell, in another sheet, within the same workbook. I have formatted them for date. How can I keep the ‘receiving cell’ clear, until I enter a date into the Primary cell?

    Thanks

All Comments

  • Author
    Replies
    • #2670658

      Reply To: Cell format

      by dklippert ·

      In reply to Cell format

      =IF(A2=””,””,A2)
      or
      =IF(ISNUMBER(A2),A2,””)

Viewing 0 reply threads