Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    102

    Help with a Formula to Blank a Linked Cell

    Hello,

    I need help in blanking out a cell filled with a linked date (1/0/1900).

    I am linking cells from one spreadsheet to another and I receive this date format (1/0/1900) on all blank cells.

    Here is my linked formula.
    ='[MS155 WO LOG.xlsx]Sheet1'!AA271

    I am using Excel 2010.

    Very much appreciate the help.

  2. #2
    Join Date
    Jun 2012
    Posts
    8
    try this:
    Code:
    =IF(ISBLANK('[MS155 WO LOG.xlsx]Sheet1'!AA271),"",='[MS155 WO LOG.xlsx]Sheet1'!AA271)

  3. #3
    Join Date
    Sep 2008
    Posts
    102
    I will try your suggestion deamo. Thank you so much for responding. :-)

Posting Permissions

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