Hello everyone, I have 2 spreadsheets. One with raw data, the other is the one i need the data in. When i copy the data across the dates change. In the original spreadsheet, the data code is 40556, and when viewed as a short date it is converted to 1/13/2011. However, the in the second spreadsheet the same cell has the same code in it, 40556, but when viewed in the short date format it is 1/14/2015 !!!
This every annoying as the date is crucial to my work in the second spreadsheet. Can anyone explain what is going on and how to ensure the dates remain consistent? David -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
