Hello! First-time poster.
I have two documents that contain cells formatted for dates. Columns in both documents are formatted the same way. When I highlight a row of cells in one document and paste it into the second document, the year changes from '09' to '13'.
Is there a way to fix this without having to "paste special" each time? (I have 1904 date system checked on both.)
Thanks for your help!
Last edited by debbiesh; 06-18-2009 at 09:42 AM.
Welcome to the forum.
Sounds like you really don't have 1904 date system in the first workbook.
Enter the same date (any date) in both workbooks, and format the cells as General. Are the numbers the same?
Entia non sunt multiplicanda sine necessitate
Sounds like the OP has changed it but not saved it in that formatOriginally Posted by shg
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Doh! Second sheet had it checked; the first sheet did not. Thanks for your help! And for the welcome.
Would you please mark the thread as Solved? (How to ... in menu bar)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks