Make your settings, as desired, then close the Options dialog box. This option should not be selected if you don't plan on saving the spreadsheet in Excel format. If this check box is selected, then formulas entered in Lotus 1-2-3 version 2.2 syntax are converted to Excel syntax. Specifically, with this option selected Excel evaluates text strings as 0 (zero), Boolean expressions as 0 or 1, and database criteria according to the rules used in Lotus 1-2-3. Based on the formulas in the 1-2-3 file, if this option isn't checked, then you might lose some data or some formulas won't calculate the same in Excel as they would have in Lotus 1-2-3. When checked, this option causes Excel to open and evaluate 1-2-3 files without losing or changing information. Notice the two options under Sheet Options these are what you need to work with:

Make sure the Transition tab is displayed. The Transition tab of the Options dialog box. (See Figure 1.) Choose Options from the Tools menu to display this dialog box.ДЇigure 1. These settings are available from the Options dialog box. If you have some old 1-2-3 files and you want to make sure that they are treated, in Excel, according to Lotus 1-2-3 'rules,' there are a couple of settings you need to pay attention to. If you want to make it compatible with SmartSuite office, then you need to convert XLS to Lotus format using Total Excel Converter. One that it will open is spreadsheets originally created in Lotus 1-2-3. Microsoft Excel produces spreadsheets in XLS format that is not compatible with various alternative applications. You probably already know that Excel will easily open a wide variety of spreadsheets stored in other formats.

Lotus 123 to excel converter download