date not correct in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rastolk@wanadoo.nl - 01 Nov 2006 15:40 GMT

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

Reply to this Message

Dave Peterson - 01 Nov 2006 15:49 GMT

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

Did you really mean to use D1 and A1?

> Hi
> I formatted cell A1 to date cell
[quoted text clipped - 10 lines]
> Thanks in advance
> Ron

Signature

Dave Peterson

Reply to this Message

rastolk@wanadoo.nl - 01 Nov 2006 16:09 GMT

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:

> =IF(D1="";"";"The date is ";text(A1;"mm/dd/yyyy"))
>
[quoted text clipped - 14 lines]
> > Thanks in advance
> > Ron

Reply to this Message