- 1). Open Microsoft Excel.
- 2). Click "File" and then "Open."
- 3). Click on the down arrow by "Files of type" of the "Open" box.
- 4). Select "Lotus 1-2-3 Files." Navigate to the directory that contains your Lotus files. The files will be listed and you can click on the filename you want and then click "Open."
Excel's "Transition formula evaluation check box" will run, and all Lotus formulas will process the same as in Lotus 1-2-3. Double-check any formulas after the conversion. Make any adjustments and recheck your formulas. - 5). Click "File" and then "Save As" to save your file. Click on the down arrow by "Save as type" of the "Save As" box. Select "Microsoft Excel Workbook." There are several Microsoft Excel options, but the common file format is "Microsoft Excel Workbook." Your Lotus file is converted.
next post