Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TechLan Consulting
 
Posts: n/a
Default lotus 1-2-3 with .123 ext

how do I convert .123 lotus files to excel?
I have no probs with .wk3 and .wk4 format - only with .123 extention

thanks
Kevin
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

I don't believe that Excel can open .123 files. You'd have to
open it in Lotus and save to a format that Excel can read.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TechLan Consulting"
wrote in message
...
how do I convert .123 lotus files to excel?
I have no probs with .wk3 and .wk4 format - only with .123
extention

thanks
Kevin



  #3   Report Post  
Timothy L
 
Posts: n/a
Default

And if you don't have Lotus installed, the only other option I could give to you is to download and install
the Windows version of OpenOffice.org 2.0 Beta 2 as it does open Lotus 123 files (ending in .wk1, .wks, and
..123).

You can find more information about OpenOffice.org at, well...
http://www.openoffice.org/

and you can download OpenOffice.org 2.0 Beta 2 he
http://download.openoffice.org/2.0beta2/index.html

Select your language (most likely English), then under "Select your operating system" select "Windows". The
last one which asks you to "Select your download site", select the location which is closest to you. So if you
live in the United States, you should select one the "USA-" options.



You should note that ONLY OpenOffice.org 2.0 Beta 2 has this converter (filter) at the time of this post. I'd
assume that later versions will continue to have it, but I cannot say for sure.

Also, I cannot tell you that this method will work, but you should give it a try.

If you don't like to install or use beta software (like me), then you might want to wait for the final version
of OpenOffice.org 2.0. I'm testing OpenOffice.org 2.0 Beta 2 on my other computer which I don't care much
about or use very often. I just happened to notice that OpenOffice.org 2.0 Beta 2 could open these files when
testing something in OpenOffice.org Calc.

This may sound like too much of a hassle for you, but I hope it helps.

--
Please post all replies to the newsgroup for the benefit of others.
Requests for assistance by email will NOT be acknowledged!



"TechLan Consulting" wrote in message
...
how do I convert .123 lotus files to excel?
I have no probs with .wk3 and .wk4 format - only with .123 extention

thanks
Kevin



  #4   Report Post  
TechLan Consulting
 
Posts: n/a
Default

Many thanks for your replies!
Kevin

"Timothy L" wrote:

And if you don't have Lotus installed, the only other option I could give to you is to download and install
the Windows version of OpenOffice.org 2.0 Beta 2 as it does open Lotus 123 files (ending in .wk1, .wks, and
..123).

You can find more information about OpenOffice.org at, well...
http://www.openoffice.org/

and you can download OpenOffice.org 2.0 Beta 2 he
http://download.openoffice.org/2.0beta2/index.html

Select your language (most likely English), then under "Select your operating system" select "Windows". The
last one which asks you to "Select your download site", select the location which is closest to you. So if you
live in the United States, you should select one the "USA-" options.



You should note that ONLY OpenOffice.org 2.0 Beta 2 has this converter (filter) at the time of this post. I'd
assume that later versions will continue to have it, but I cannot say for sure.

Also, I cannot tell you that this method will work, but you should give it a try.

If you don't like to install or use beta software (like me), then you might want to wait for the final version
of OpenOffice.org 2.0. I'm testing OpenOffice.org 2.0 Beta 2 on my other computer which I don't care much
about or use very often. I just happened to notice that OpenOffice.org 2.0 Beta 2 could open these files when
testing something in OpenOffice.org Calc.

This may sound like too much of a hassle for you, but I hope it helps.

--
Please post all replies to the newsgroup for the benefit of others.
Requests for assistance by email will NOT be acknowledged!



"TechLan Consulting" wrote in message
...
how do I convert .123 lotus files to excel?
I have no probs with .wk3 and .wk4 format - only with .123 extention

thanks
Kevin




  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

"TechLan Consulting" wrote...
Many thanks for your replies!

....
"Timothy L" wrote:
And if you don't have Lotus installed, the only other option I
could give to you is to download and install the Windows version
of OpenOffice.org 2.0 Beta 2 as it does open Lotus 123 files
(ending in .wk1, .wks, and ..123).

....

OpenOffice 2.0 beta makes a hash of it. It only imports the first
worksheet's name correctly. All other worksheets' names are shown as test.

FWIW, Gnumeric also claims to open .123 files, but has problems doing so.

In addition to 123 itself, Quattro Pro version 10 and later can open .123
files mostly without problems, and DataViz's Conversion Plus claims to
handle .123 files (I've never used it).


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lotus Documents in Excel Krissy86 Excel Discussion (Misc queries) 1 August 30th 05 06:05 PM
text and numbers same cell and formulas still work (like lotus) rmoore Excel Worksheet Functions 4 July 20th 05 07:02 PM
Lotus v9.5 has .123 extension - how do I open or link Excel to th. ss123 Excel Discussion (Misc queries) 3 April 7th 05 09:34 PM
How to covert old Lotus 123 files with .123 extension to Excel? Kate Excel Discussion (Misc queries) 2 January 31st 05 06:51 PM
Still Convert Lotus 123 to Excel 2003 becky Excel Discussion (Misc queries) 2 December 24th 04 02:14 AM


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"