=if(len(trim(A1))=0,"",A1)

But that only makes the cell look blank - it isn't blank because it contains
a formula. It won't contain a date unless you format it as a date. It would
contain zero if you used

=A1


--
Regards,
Tom Ogilvy



LA wrote in message
...
COPYING CONTENTS OF A BLANK CELL USING A FUNCTION DOES NOT
RESULT IN A BLANK CELL BUT A CELL WITH A DATE.