Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1/1/1900 issues
I have dates in an access database represented as 1/1/1900. When I generate
a table query and cut and paste the data from the access query into excel the 1/1/1900 dates are pasted into excel as 1/2/1900. Why is the date being incremented by one day during the cut and paste procedure. If I export the data directly from the access query using excel file format the dates export unchanged. Something in the cut and paste operation is causing an issue. Any ideas why? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Risk Issues register | Excel Discussion (Misc queries) | |||
Issues in Opening a file | Excel Worksheet Functions | |||
Issues with saving text file | Excel Worksheet Functions | |||
Compatibility issues with macros (2000 vs. 2003)? | Excel Discussion (Misc queries) | |||
PDF hyperlink issues | Excel Discussion (Misc queries) |