date not correct in cell

  • Thread starter Thread starter rastolk
  • Start date Start date
R

rastolk

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
 
=IF(D1="";"";"The date is ";text(A1;"mm/dd/yyyy"))

Did you really mean to use D1 and A1?
 
Hi Dave

Yes that will do
(D1 is correct if that cell is not filled the formular will not
appears)

Strange situation same formular with other cells in the same sheet
are oke

Thanks
Ron





Dave Peterson schreef:
 
Back
Top