If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
date not correct in cell
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 |
#2
|
|||
|
|||
date not correct in cell
=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 |
#3
|
|||
|
|||
date not correct in cell
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")) 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 |
Thread Tools | |
Display Modes | |
|
|