Lotus 1-2-3 Wk4 File Converter Microsoft
How to convert Lotus 1-2-3 version 4.x spreadsheet file (.wk4) to Microsoft Excel XLS file format. I am archiving some old tax records and find that I did some of the old tax computations with Lotus 1-2-3. (WK1 and WK4 file extensions). I have Excel 2010 (and Excel. How to convert Lotus 1-2-3 version 4.x spreadsheet file (.wk4) to Microsoft Excel XLS file format.
From Fantastic Lotus 1-2-3 Converter is used to convert Lotus 1-2-3 files to Excel, Access, SPSS, FoxPro, DBF, CSV(Text), XML, HTML file formats and SQL script. Fantastic Lotus 1-2-3 Converter supports following DBF file formats for output: dBase 3, dBse 3 Memo, dBase 3 Plus, dBase 3 Plus Memo, dBase 4, dBase 4 Memo, dBase 4 SQL, dBase 4 SQL Sys, dBase 5, dBase 7, dBase 7 Memo, FoxBase 1, FoxBase 2, FoxPro, FoxPro 2, FoxPro Memo, HyperSix, Visual FoxPro 3, Visual FoxPro 3 AutoIncrement, Visual FoxPro 3 Binary.
Hi isltt, sorry thaught so I see you want to convert Lotus to excel. Well its easy I never seen an application that converts it.
As far as I know You will have to do it manually. But here is how to do the most of it to excel. Opening WK4 Files To open Lotus 1-2-3 WK4 files in Microsoft Excel version 5.0, you must obtain the Lotus 1-2-3 WK4 file converter. The Lotus 1-2-3 WK4 file converter is available in the 'Lotus 1-2-3 WK4 File Converter' (WE1130) Application Note. NOTE: Microsoft Excel 7.0 and Microsoft Excel 97 include a Wk4 file converter.
The converter included with Microsoft Excel 7.0 allows you to read the Lotus 1-2-3 Wk4 file format. The converter in Microsoft Excel 97 allows you to read and write the Wk4 format. Formatting When you open a Lotus 1-2-3 worksheet or workbook, Microsoft Excel applies the formatting stored in any associated.fmt,.fm3, or.all files. Be sure that the associated formatting file is stored in the same folder as the.wk? If you resave a Lotus 1-2-3 file in the Microsoft Excel (.xls) format, Microsoft Excel saves the spreadsheet data and formatting in a single workbook file. Objects In Microsoft Excel 5.0, when you open a Lotus 1-2-3 WK4 file, any drawing objects, such as macro buttons, text boxes, and lines, are not converted.
Additionally, worksheet names are displayed as the Lotus 1-2-3 default: A, B, C, and so on. The Lotus 1-2-3 WK4 file converter does not convert drawing objects on a worksheet. Charts Microsoft Excel 4.0 and Later: In Lotus 1-2-3, versions 3.x and later, you can create a graph on a chart sheet or create the chart as an object on the worksheet. In Lotus 1-2-3, version 2.x, if you use the WYSIWYG add-in, you can place a graph on a worksheet.
By default, Microsoft Excel automatically converts any charts associated with a Lotus 1-2-3 worksheet. You can use the following setting in the Excel4.ini and Excel5.ini files to suppress the creation of chart sheets when you open a Lotus 1-2-3 file: LoadChartWnd=0 Because Microsoft Excel can read Impress (.fm3) files and Allways (.all) formatting files, you can import a Lotus 1-2-3 worksheet that contains a chart on the worksheet.
The chart appears on the worksheet as it does in Lotus 1-2-3. Microsoft Excel 2.x and 3.x: When you import a file that contains a graph, Microsoft Excel 2.x and 3.x display a prompt for each graph that is stored with the worksheet or is located on the worksheet.
You are prompted whether to convert the file to a Microsoft Excel chart. If you click Yes, Microsoft Excel creates a new chart window. In Microsoft Excel 3.x, you can then copy the chart to the worksheet. Calculations Whenever you open a Lotus 1-2-3 file, the Transition Formula Entry check box is selected.
When this feature is selected, Microsoft Excel converts formulas that are entered with Lotus 1-2-3 syntax to Microsoft Excel syntax and makes names defined in Microsoft Excel behave as defined names do in Lotus 1-2-3. Microsoft Excel calculates formulas differently from Lotus 1-2-3.
When a cell that contains text is used in a formula, Lotus 1-2-3 assigns a value of 0 (zero) to the cell. In Microsoft Excel, you cannot combine text and numeric entries in the same formula.
Convert Wk4 To Excel 2013
However, when you use a worksheet function in Microsoft Excel, a value of 0 is assigned to cells that contain text. For example, if you clear the Transition Formula Evaluation check box, and you type text in cell A1 and the value 100 in cell B1; the formula =A1+B1 returns the #VALUE! However, the worksheet formula =SUM(A1,B1) returns the value 100. Lotus 1-2-3 evaluates Boolean expressions to 0 or 1 and displays 0 or 1 in the cell. For example, in Lotus 1-2-3, the expression 2.
I'm going to suggest a completely different tactic that will ultimately give you much better results. Buy a copy of Lotus SmartSuite Millenium Edition 9.8 and use IT to convert your files into their corresponding Microsoft versions. If you do a quick search on, you can pick up a copy of SS for about $20 including shipping. If you try to use Microsoft Office to open the Lotus files as some would suggest, you'll find the versions it supports are fairly old and it doesn't do all that good a job of converting. However, Lotus 1-2-3, Word Pro and Freelance all support reading / writing their Microsoft Office counterparts fairly well. I do it all the time.
Lotus 1-2-3 Wk4 File Converter
Anyway, for $20, you can't go wrong.