close
    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

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

    1 Answer

    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

    Wilmaandfreddie

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

    Moderator
    You asked how to convert a lotus file. I gave you how to do this. I assumed you had Excel since you mentioned it.
    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
    Colleen

    Moderator
    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


    Top contributors in Uncategorized category

     
    ROMOS
    Answers: 18061 / Questions: 154
    Karma: 1101K
     
    Colleen
    Answers: 47269 / Questions: 115
    Karma: 953K
     
    country bumpkin
    Answers: 11322 / Questions: 160
    Karma: 838K
     
    Benthere
    Answers: 2392 / Questions: 30
    Karma: 760K
    > Top contributors chart

    Unanswered Questions

    466796
    questions
    722289
    answers
    785932
    users