Hi

Is there a way to import .123 files into excel 2007 ?

Thanks

Open Office will open .123 files, then you can save them in Excel format.
--
David Biddulph

"rb999" wrote in message
...
Hi

Is there a way to import .123 files into excel 2007 ?

Thanks

Hi,

About converting worksheets between Excel and Lotus 1-2-3
Some of the content in this topic may not be applicable to some languages.

Converting files

Saving in Microsoft Excel file format Excel stores the file format of any
file you open. When you save a file, Excel uses the same format the file was
in when you opened it. For example, if you open a Lotus 1-2-3 file with a
..wk3 extension, Excel saves the file as a Lotus 1-2-3 file with a .wk3
extension. If you make changes to the file in Excel, you should save the file
in an Excel file format to be sure all of your changes are saved. To do this,
be sure to use the Save As command and select Microsoft Excel Workbook in the
Save as type box.

Changing the file name extension When you save a workbook as a different
type by changing the file format in the Save as type box, you do not have to
change the file name, because Excel saves a copy of the workbook with a
different file name extension. For example, a Lotus 1-2-3 Release 4.0 file
has a file name extension of .wk4; Excel Workbook format uses the .xls file
name extension.

Typing a new extension in the File name box, or renaming the file with a new
extension in the folder window, is not sufficient to change the file type.
You must also change the Save as type box to the file type you want.

Applying formatting from associated Lotus 1-2-3 files When you open a
Lotus 1-2-3 worksheet or workbook in Excel, Excel applies the formatting in
the associated .fmt, .fm3, or .all file. Make sure the associated file is
stored in the same folder as the .wk? file. If you save a Lotus 1-2-3 file in
Excel format, Excel saves the spreadsheet data and formatting in a single
workbook file.

Converting formulas

Using Lotus 1-2-3 rules to calculate formulas When you open a Lotus 1-2-3
worksheet in Microsoft Excel, the Transition formula evaluation check box is
automatically selected for that sheet to ensure that Excel calculates the
formulas according to the Lotus 1-2-3 rules.

If you save a Lotus 1-2-3 worksheet as an Excel worksheet, the Transition
formula evaluation check box remains selected and Excel will calculate the
formulas according to the Lotus 1-2-3 rules until you clear it.

How cells are used in formulas Once you have converted a Lotus 1-2-3 file
to an Excel workbook, you can examine the relationships of the cells and
formulas within the worksheet by using the worksheet audit commands.

Some formulas may not convert If a formula can't be converted to an Excel
formula, the worksheet shows the last value calculated for the formula in
Lotus 1-2-3.

Converting macros

Microsoft Excel 2000 and later versions do not run Lotus 1-2-3 macros. You
can rewrite any macros that you need in Visual Basic for Applications. For
information about writing Excel macro code, see Visual Basic Help (Microsoft
Visual Basic Help: To get help for Visual Basic in Excel, point to Macro on
the Toolsmenu, and then click Visual Basic Editor. On the Help menu, click
Microsoft Visual Basic Help.).

Challa Prabhu

"rb999" wrote:

Hi

Is there a way to import .123 files into excel 2007 ?

Thanks

Hi,

Tips for Importing Lotus 1-2-3 Files to Excel:
http://support.microsoft.com/kb/q61941/

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.

Challa Prabhu

"rb999" wrote:

Hi

Is there a way to import .123 files into excel 2007 ?

Thanks

The OP didn't ask about .wk4 files. The question was about .123 files.
--
David Biddulph

"challa prabhu" wrote in message
...
Hi,

Tips for Importing Lotus 1-2-3 Files to Excel:
http://support.microsoft.com/kb/q61941/

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.

Challa Prabhu

"rb999" wrote:

Hi

Is there a way to import .123 files into excel 2007 ?

Thanks