Forum Home
Press F1
Thread ID: 137616	2014-07-29 10:22:00	Excel 2013 from csv date Query	Neil F (14248)	Press F1

Post ID	Timestamp	Content	User
1380328	2014-07-29 10:22:00	AQ colleague downloads bank files in csv format and emails them to me. I save them as Excel 2013 and do lots of different sorts e.g by payee or value I copy these into another Excel 2013 file according to their expense category. The date transfers inaccurately and copies as 1 day prior to actual day's date and reduces the year by 4 e.g. 19/8/2013 gets copied as 18/8/2009 and 04/06/2014 as 03/06/2010 This occurs whether I use ordinary copy paste or any of the options of Copy paste special. The year I correct by "find and replace" but the day date is an individual override. Any ideas?	Neil F (14248)
1380329	2014-07-29 11:09:00	I recall having that issue for graphing a while back. I think you need change the date option to 1904 under tools menu then advanced - calculation. Can't recall exact steps.	kahawai chaser (3545)
1380330	2014-07-31 02:10:00	Probably the "1904" flag answers.microsoft.com answers.microsoft.com	kingdragonfly (309)
1380331	2014-08-03 10:20:00	Many thanks kahawai chaser and kingdragonfly. kahawai I did what you suggested and it works. The pity from my viewpoint is that once having ticked the box in the workbook is no "saving" or "apply" option. I think I should like to find a "System" Date setting, Now I have tracked down the Microsoft Office "blurb" on this which explained very clearly the difference from 1900 date systems and 1904 date system. I had not mentioned in my original post that In get the files from an Apple Macintosh user -Numbers. The Microsoft blurb advises that Mac is defaulted to 1904 date system and gives a clear example of the 4years and 1 day variance. Thanks again for helping me . Neil	Neil F (14248)
1