Converting .123 file to Excel

[Ming]

Hi there,

Please help. How to convert a .123 file to Excel 2000?
Thank you.


Cheers,
Ming

 

[Norman Harker]

Hi Ming!

If they are .123 files you need to use Lotus to open them and then
save them as .wk4 files which can then be opened by Excel 2000


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Harlan Grove]

If they are .123 files you need to use Lotus to open them and then
save them as .wk4 files which can then be opened by Excel 2000

...

Actually, if the OP has a version of 123 that can open .123 files, it's better
to use 123 to save them as .XLS files. The reason is that more recent .123 files
can hold 65536 rows per worksheet, but .WK4 format only stores the top 8192
rows, so saving in .WK4 format could cause data loss.

 

[Norman Harker]

Hi Harlan!

Thanks for that. I haven't used the latest editions of Lotus. In any
event there seems little point in saving as a Wk4 when Lotus can save
in xls format. And when you add the prospect of data loss it's a
non-starter.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

...
..

Actually, if the OP has a version of 123 that can open .123 files, it's better
to use 123 to save them as .XLS files. The reason is that more recent .123 files
can hold 65536 rows per worksheet, but .WK4 format only stores the top 8192
rows, so saving in .WK4 format could cause data loss.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup

archives.