=IF(D1="";"";"The date is ";text(A1;"mm/dd/yyyy"))

Did you really mean to use D1 and A1?

wrote:

Hi
I formatted cell A1 to date cell
till sofar the date 01-11-06 appears as requested in that cell

When I copy A1 to B1 (B1=A1) it gives also the correct date

When I put in B1 the formule
=IF(D1="";"";"The date is ";A1) it shows The date is 39022

(programmed in Excel2003 and copied to Excel2000)
What is wrong
Please help
Thanks in advance
Ron

--

Dave Peterson