Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Empty Date Cell as Zero | Excel Discussion (Misc queries) | |||
if cell has date value how to calculate other cell values | Excel Discussion (Misc queries) | |||
How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |