Referencing a cell.

[PAL]

This might be a double post. If so my apoligies.

Have a row with 6 columns. 2 are text, the others are numbers. When I
reference them on another sheet, if they are blank, the text fields come up
with a 0, the others blank dates come up with 0-jan-00. To fix, I must
reformat. Is there a way to get blanks when the referenced cell is blank
without reformating.

A2 text
B2 date
C2 date
D2 text
E2 date
F2 date

Thanks.

 

[Dave Peterson]

=if(sheet99!a1="","",sheet99!a1)

The cell with the formula will look blank if the "sending" cell is empty.