Forum Discussion
Solved
Linking Dates in separate Excel workbooks
I linked data in two separate workbooks, and all of text data populated correctly, however my dates are not populating correctly. When I look at the dates using a "general" format, the duplication i...
AntoinetteMB The dates are exactly 4 years apart. That tells me that the Employees Records sheet has Use 1904 data system (Excel, Preferences, Calculation, almost at the bottom) checked. Uncheck it!
AntoinetteMB The dates are exactly 4 years apart. That tells me that the Employees Records sheet has Use 1904 data system (Excel, Preferences, Calculation, almost at the bottom) checked. Uncheck it!
Thank you so much!! I would never have figured that out! Riny_van_Eekelen