date values change when I copy an excel sheet to a new book
Thank you so much - you are absolutely correct - all fixed after hours of
frustration.
I owe you one.
Manning Stoller
"Jerry W. Lewis" wrote:
Tools|Options|Calculation The source workbook has "904 Date System" checked,
and the receiving workbook doesn't. Excel stores dates as the number of days
since a particular reference date. This option defines the reference date.
Both workbooks must be prepared to interprete the number of days in the same
way unless you are prepared to do some intermediate translation.
Jerry
"man818" wrote:
When I copy a spreadsheet to another workbook, the data values all change by
4 years backward.
|