| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid discrepancy when copy date?
Iwhen I copy the date from one file to another ,the date changed.
For example:original date is "May 24,2006" but it changed into "May 23,2002" when I copy them from one file to another.And it always change the year from other into 2002. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to avoid discrepancy when copy date?
"Bill.liu" wrote in message
... Iwhen I copy the date from one file to another ,the date changed. For example:original date is "May 24,2006" but it changed into "May 23,2002" when I copy them from one file to another.And it always change the year from other into 2002. Look at Tools/ Options/ Calculation: 1904 date system. I presume that one file has this set and the other unset. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
| How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
| Copy Color Formats Based On Column Date Values | Excel Discussion (Misc queries) | |||
| How do I copy a date from excel to a outlook calender? | Excel Discussion (Misc queries) | |||
Linear Mode
