Top Navigational Bar

Importing Lotus Spreadsheet Eliminates "$" An
DocumentID: 650141
Revision Date: 29-Feb-96 8:28:57 PM

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

Problem

Solutions: Problem :
The customer made a simple one-column spreadsheet in Lotus 1-2-3. This file consisted of numerical data in cells A1 through A3. He saved this file as a .WK1 file in Lotus.

The customer then imported the file into WordPerfect 5.1 for DOS using the Ctrl-F5 spreadsheet import feature. Now the file is properly in a table format but all the dollar signs ($) and all amounts in cents (.45 for example) are missing. The customer has had the same problem with other spreadsheets.

Answer:
A possible work around for the problem is done in Lotus by globally changing the format of the cells to a fixed format. This, however, will drop all dollar signs in Lotus, and they will not appear in the table in WP.

Status:      Next Interim after 11/06/89
***|next interim|***
Press Enter on link token.

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.