![]() |
Importing Excel File Containing Decimals Leav |
The information in this document applies to:
WordPerfect® 5.1 for DOS
Problem
Symptoms: Importing an Excel file with numbers rounded to one decimal place leaves off trailing zeros. If the decimal place is a 0, as in 3.0 or 1.0, the trailing 0 gets cut, leaving just the 3 or 1. Numbers formatted with one of the other formats in Excel, e.g., #,##0.0_);(#,##0), are not formatted correctly when the file is imported. This also applies to spreadsheet links. Solutions: Saving the file in .WK3 (Lotus) format from Excel will allow the information to be retrieved into WordPerfect without this problem. Status: Enhance ***|enhance|*** Press Enter on link token to view statement. |
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. |