Thread: How to avoid discrepancy when copy date?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill.liu Bill.liu is offline
external usenet poster
  
Posts: 3
Default 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.
Reply With QuoteReply With Quote