| 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 |
| 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 | |||
Threaded Mode
