Top Navigational Bar

Dates In Excel File Import Incorrectly
DocumentID: 610409
Revision Date: 29-Feb-96 1:34:31 PM

The information in this document applies to:
WordPerfect® 5.1 for DOS

Problem

Symptoms: The customer has a Microsoft Excel file (2.1) that doesn't seem to import correctly into a table. The dates come in as Julian format--which makes them just large numbers. Solutions: The date format was user-defined from within Excel. User-defined formats will not import into WordPerfect 5.1 for DOS, and that explains why these dates came across incorrectly.

Answer:

Details:


Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.