English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I have exchanged Lotus 1-2-3 files with colleagues. They tell me that they can open the file with Excel and read it on the screen, but when they print it there are large black letters obscuring most of the spreadsheet, rendering it useless!

2006-12-01 13:12:49 · 1 answers · asked by AL P 1 in Computers & Internet Software

1 answers

Wow. Haven't seen Lotus for years. However, try opening your Lotus file and check out the "File, Save AS" options. See if you can save as ASCII, CSV, txt.

Then, open a new Excel document and click File, Open or File, Import.

Because the ASCII, CSV, or txt files are not Excel files, you will have to indicate that the file is delimited and how it is delimited.

ASCII delimited fields by enclosing each field in quotes and separating them with a comma.

CSV simply separates them by comma.

The data will read in. When all the data are in the Excel file, immediately name and save it, and be sure the filetype (on the bottom) indicates Excel worksheet.

2006-12-01 17:14:04 · answer #1 · answered by TheHumbleOne 7 · 0 0

fedest.com, questions and answers