=IF('other sheet'!A2="","",'other sheet'!A2)

HTH
Kostis Vezerides

On Jun 27, 7:04 pm, JayDee wrote:
Microsoft Excel 2007: If there are cells in the original worksheet (file)
that contain dates and other cells that are "date" formatted; however, no
dates have been entered, how can I show a "blank" cell on the worksheet of
the linked file? Currently, if the date formatted cell is blank on the
original file, the second file is auto filled with the date of 1/10/1900. I
need the linked worksheet to show blank cells until an actual date is entered
in the cells of the original file.