Open the Lotus 1-2-3 spreadsheet and Excel should process the file according to the settings you made. 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.
One that it will open is spreadsheets originally created in Lotus 1-2-3. Make your settings, as desired, then close the Options dialog box. &0183 &32 You probably already know that Excel will easily open a wide variety of spreadsheets stored in other formats. 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. You probably already know that Excel will easily open a wide variety of spreadsheets stored in other formats.
0 kommentar(er)
