Thread
:
dates in Excel 2003
View Single Post
#
2
Ron Rosenfeld
Posts: n/a
On Mon, 3 Jan 2005 20:07:02 -0800,
wrote:
I have excel 2003 and a client has another older version. When copying a date
(ie 6/30/04) into a new excel 2003 spreadsheet I get an output showing 4
years earlier and sometimes 1 or 2 days off (ie 6/29/00). Is there a fix for
this? Desperately need help on this.
Tools/Options/Calculation
Workbook Options
Make sure 1904 Date system is either selected or deselected on both machines.
--ron
Reply With Quote