D
DR
Strange Excel behavior
I have a billing template I created in Excel that works
perfectly and has for several years. Today I copied a
worksheet derived from that template and pasted it into a
new workbook. All text, numerical values and formulae
copied correctly but every date came across as four years
and one day earlier, i.e., 5/12/2004 copied to the new
sheet as 5/10/2000. The same thing occurs with every
statement derived from this template.
Copy and paste within the statements functions properly.
Copy and paste within a new workbook functions properly,
as does the NOW() function within the statements and
within new workbooks.
Dates copied from a new workbook and pasted into another
new book work correctly.
NOW() copied from a statement into a new book functions
properly.
NOW() copied from a statement and paste special/values
exhibits the above malfunction.
Please help - I'm going nuts here...
Version 8.0.0.3515
Language Neutral
Created Sunday, November 17, 1996, 12:00:00 AM
Modified Sunday, November 17, 1996, 12:00:00 AM
Location C:\Program Files\Microsoft Office\Office
Size 5.33 MB (5,599,504 bytes)
Size on disk 5.34 MB (5,603,328 bytes)
Purchased with MS Office Pro 97
Norton updated today reports no infections.
There are no macros on the template.
Dates copied from the File INVOICE.XLT that came with
Office Pro work when pasted into a new sheet.
TIA
DR
I have a billing template I created in Excel that works
perfectly and has for several years. Today I copied a
worksheet derived from that template and pasted it into a
new workbook. All text, numerical values and formulae
copied correctly but every date came across as four years
and one day earlier, i.e., 5/12/2004 copied to the new
sheet as 5/10/2000. The same thing occurs with every
statement derived from this template.
Copy and paste within the statements functions properly.
Copy and paste within a new workbook functions properly,
as does the NOW() function within the statements and
within new workbooks.
Dates copied from a new workbook and pasted into another
new book work correctly.
NOW() copied from a statement into a new book functions
properly.
NOW() copied from a statement and paste special/values
exhibits the above malfunction.
Please help - I'm going nuts here...
Version 8.0.0.3515
Language Neutral
Created Sunday, November 17, 1996, 12:00:00 AM
Modified Sunday, November 17, 1996, 12:00:00 AM
Location C:\Program Files\Microsoft Office\Office
Size 5.33 MB (5,599,504 bytes)
Size on disk 5.34 MB (5,603,328 bytes)
Purchased with MS Office Pro 97
Norton updated today reports no infections.
There are no macros on the template.
Dates copied from the File INVOICE.XLT that came with
Office Pro work when pasted into a new sheet.
TIA
DR