Karma: 0

How do I convert a Lotus 123 file to Microsoft in Windows 7

I have a Lotus 123 spreadsheet and need to open this in Windows 7. I could use any of the Microsoft programs, ie. Excel or Word. Please advise

Answer this

0 Views: 1187 Answers: 1 Posted: 12 years ago

Tags: lotus smartsuite file conversion

1 Answer

Colleen

Karma: 2042400

Instructions
1
Open the file in Lotus 1-2-3, then click "File," then "Save As" and save the file as a "WK4" file.

2
In Microsoft Excel, click "File," then click "Open," then locate the WK4 file on your computer.

3
Ensure that the "Transition formula evaluation" check box is checked (this should happen automatically).

4
Click "Open." Excel will open the file and convert the Lotus 1-2-3 formulas to Excel formulas.

Read more: How to Convert Lotus 123 to Microsoft Excel | eHow.com http://www.ehow.com/how_7323820_convert-lotus-123-microsoft-excel.html#ixzz29vR3xPQs

12 years ago. Rating: 1
Comment this answer

Wilmaandfreddie

I don't have Lotus 123 have received file as attachment to email. Sender does not have Microsoft

commented 12 years ago

Colleen

You asked how to convert a lotus file. I gave you how to do this. I assumed you had Excel since you mentioned it.

commented 12 years ago

Wilmaandfreddie

I DO have excel but cannot open the .123 file as it is not supported. You state 'Open the file in Lotus 1-2-3' but I don't have Lotus 1-2-3

commented 12 years ago

Colleen

Instructions
1
Locate the Lotus .123 file that you wish to open. If it has a “.123” appendage, you need to rename it to have a “.wk4” appendage. This will allow Excel to read the file.

2
Right click the Lotus 123 (.wk4) file.

3
Select “Open with…” and select Microsoft Excel. Excel will open the file with all associated information and formatting. If you wish to convert to a native Excel file, merely save it, making sure to select the Excel format.

Read more: How Can I Open a Lotus 123 File? | eHow.com http://www.ehow.com/how_6144331_can-open-lotus-123-file_.html#ixzz29vU1qDiE

commented 12 years ago