ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lotus 123 files (https://www.excelbanter.com/excel-discussion-misc-queries/110130-lotus-123-files.html)

Comcast newsgroup

Lotus 123 files
 
I have to change from Lotus 9.8 with file type ***.123 to Excel 2003. I use
the @roundup formula a lot and when I save in .wk4 format I lose all these
formula's. does anyone know of a newer convertor file for Excel to allow
the Importing or opening of the files in .123 format???

David





Dave Peterson

Lotus 123 files
 
I don't use 123, but I've read posts that dataviz offers a conversion program:
http://support.dataviz.com

But until that time, maybe you could use a workaround.
Inside 123, change all your @roundup() to $$roundup()'s (edit|replace???)

Then save the file as .wk4 and open in excel and reverse the process.

If that doesn't work, maybe you can pick out a function that you don't use that
requires two arguments, change roundup() to that function and reverse the
process in excel.

Comcast newsgroup wrote:

I have to change from Lotus 9.8 with file type ***.123 to Excel 2003. I use
the @roundup formula a lot and when I save in .wk4 format I lose all these
formula's. does anyone know of a newer convertor file for Excel to allow
the Importing or opening of the files in .123 format???

David


--

Dave Peterson

Jim Rech

Lotus 123 files
 
I've read posts that dataviz offers a conversion program

Conversions Plus is the program's name. I bought it years ago just so I
could be sure about whether it handles .123 files since the web site did not
directly say it. (It does).

--
Jim
"Dave Peterson" wrote in message
...
|I don't use 123, but I've read posts that dataviz offers a conversion
program:
| http://support.dataviz.com
|
| But until that time, maybe you could use a workaround.
| Inside 123, change all your @roundup() to $$roundup()'s (edit|replace???)
|
| Then save the file as .wk4 and open in excel and reverse the process.
|
| If that doesn't work, maybe you can pick out a function that you don't use
that
| requires two arguments, change roundup() to that function and reverse the
| process in excel.
|
| Comcast newsgroup wrote:
|
| I have to change from Lotus 9.8 with file type ***.123 to Excel 2003. I
use
| the @roundup formula a lot and when I save in .wk4 format I lose all
these
| formula's. does anyone know of a newer convertor file for Excel to
allow
| the Importing or opening of the files in .123 format???
|
| David
|
|
| --
|
| Dave Peterson




All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com