Lotus 123 to excel

11-10-2005, 12:20 PM #1 Lotus 123 files in Excel? Is it possible to open Lotus 123 files in Excel?If so, what would I need and or how would I go about this? 11-10-2005, 03:25 PM #2 RE: Lotus 123 files in Excel? From XL, File>Open & navigate to where the files are stored. If they don'tappear in the content window, open the 'Files of Type:' list @ the bottom ofthe dialog box & choose 'Lotus 1-2-3 Files (*.wk?)'.Good Luck |:>)"KLB" wrote:> Is it possible to open Lotus 123 files in Excel?>> If so, what would I need and or how would I go about this?>>> 11-10-2005, 05:55 PM #3 Re: Lotus 123 files in Excel? Only if they are the older .wk4 type or before. There is no support for thelater version Lotus files.--RegardsKen....................... Microsoft MVP - ExcelSys Spec - Win XP Pro / XL 97/00/02/03------------------------------*------------------------------*----------------It's easier to beg forgiveness than ask permission :-)------------------------------*------------------------------*----------------"KLB" [email protected]> wrote in messagenews:[email protected]...> Is it possible to open Lotus 123 files in Excel?>> If so, what would I need and or how would I go about this?> 11-10-2005, 10:55 PM #4 Re: Lotus 123 files in Excel? Thanks Folks, turns out that the files were the newer type with the .123extension.Looks like software always dies a slow death.

01-18-2005, 02:06 PM #1 LOTUS 123 TO EXCEL 2003 I work for a company that is converting all of their Lotus 123 (Dos VersionRelease 2.2) spreadsheets to Excel.I do not understand this Lotus formula =AND(A9>=$AA$2,A9AC2.The "A" column is full of dates.AA2 has another date January 1, 2005, and AB2 has another date January 31,2005.A9 is a dashed line no date or pertinent information. When I can theformula to A10 which is the first cell with a date the AC2 cell now says trueor false.I want the formula to look at the whole column and determine which dates arein between 01-01-05 and 01-31-05. Can someone help me write this formula.--bb 01-18-2005, 03:06 PM #2 Re: LOTUS 123 TO EXCEL 2003 becky wrote...>I work for a company that is converting all of their Lotus 123 (DosVersion>Release 2.2) spreadsheets to Excel.>>I do not understand this Lotus formula =AND(A9>=$AA$2,A9cell>AC2.....This would be the Excel translation of a 123 formula. It's checkingwhether the value of cell A9 falls between the values of cells AA12 andAB12. It does this by checking if A9 is greater than or equal to AA2*and* then whether A9 is less than or equal to AB2. The original 123formula would have been+A9>=$AA$2#AND#A9>A9 is a dashed line no date or pertinent information. When I can the>formula to A10 which is the first cell with a date the AC2 cell nowsays true>or false.That's what the AND function does in Excel. The 123 formula would havereturned 1 (corresponding to TRUE in Excel) or 0 (corresponding toFALSE in Excel).>I want the formula to look at the whole column and determine whichdates are>in between 01-01-05 and 01-31-05. Can someone help me write thisformula.Excel can do that, but how do you want to results of which cells in colA are between these dates and which aren't displayed? It appears theoriginal 123 workbook displayed them as 1s (between) or 0s (notbetween). 01-18-2005, 05:06 PM #3 Re: LOTUS 123 TO EXCEL 2003 HarlanThank you for the information. That is what I thought it was doing, but notbeing a Lotus user I was not sure. I still need the formula to be

A 0 or a 1only in Excel. We are trying to get all of our documents convert but I amrunning into a lot of these issues. Do you know how to write the Excelversion of this formula? Please help if you can.ThanksBecky"Harlan Grove" wrote:> becky wrote...> >I work for a company that is converting all of their Lotus 123 (Dos> Version> >Release 2.2) spreadsheets to Excel.> >> >I do not understand this Lotus formula =AND(A9>=$AA$2,A9> cell> >AC2.> ....>> This would be the Excel translation of a 123 formula. It's checking> whether the value of cell A9 falls between the values of cells AA12 and> AB12. It does this by checking if A9 is greater than or equal to AA2> *and* then whether A9 is less than or equal to AB2. The original 123> formula would have been>> +A9>=$AA$2#AND#A9>> >A9 is a dashed line no date or pertinent information. When I can the> >formula to A10 which is the first cell with a date the AC2 cell now> says true> >or false.>> That's what the AND function does in Excel. The 123 formula would have> returned 1 (corresponding to TRUE in Excel) or 0 (corresponding to> FALSE in Excel).>> >I want the formula to look at the whole column and determine which> dates are> >in between 01-01-05 and 01-31-05. Can someone help me write this> formula.>> Excel can do that, but how do you want to results of which cells in col> A are between these dates and which aren't displayed? It appears the> original 123 workbook displayed them as 1s (between) or 0s (not> between).>> 01-18-2005, 11:06 PM #4 Re: LOTUS 123 TO EXCEL 2003 "becky" [email protected]> wrote...> . . . Do you know how to write the Excel>version of this formula? Please help if you can.....>>>I do not understand this Lotus formula =AND(A9>=$AA$2,A9>>>cell AC2.....If you need 1s and 0s, change this particular formula to=--AND(A9>=$AA$2,A9Unlike 123, Excel includes True and False values along with numbers, textand errors. They can be converted to numeric 1 and 0 by applying anydo-nothing arithmetic operator like +0, *1 or double unary minus[-(-(x))=-(-x)=x].

Deplymentyesnonovec Vectorial Image (text)yesnonovhd VHDL datayesnonovim VIMyesnonovkm VICE Keyboard Mappingyesnonovml Vector Markup Languageyesnonovmt Valve Texture Materialyesnonowrs VICE Setupyesnonovs Visual SINTACyesnonowsc VICE definitionsyesnonovsh Vertex Shaderyesnonovssscc Visual Studio Source Controlyesnonovtt WEB VTTyesnonowat Watch Nameyesnonowcm WordPerfect macroyesnonovsx Magic plugin interfaceyesnonovsz Visual Studio Wizardyesnonovxx Magix plugin interfaceyesnonow Source fileyesnonowaon WaoN makefileyesyesnowcs Corel datayesnonowdsl Wireless Digital Suscriber Linkyesnonoweb Source fileyesnonowepn LuaDC Scriptyesnonower Windows Error Reportyesnonower VICE Paletteyesnonowf LuaDCyesnonowff WinFF Presetsyesnonowin AAF Win makefileyesnonowin32 Makefileyesnonowj2 Lotus 123yesnonowj3 Lotus 123yesnonowjf WinZip Job Fileyesnonowk1 Lotus 123 workbookyesnonowk3 Lotus 123 workbookyesnonowk4 Lotus 123 workbookyesnonowl1 Wolf3D GameMapyesnonowml Wireless Markup Languageyesnonowp Kompass (DAV) Trackyesyesnowp Kompass (DAV) Waypointsyesyesnowpd WordPerfectyesyesnowpl Video playlistyesnonowpo Holux (gm-100)yesyesnowpr Alan Map500 waypoints and routesyesyesnowps Works textyesyesnowpt WordPerfect templateyesnonowpt CompeGPS datafileyesyesnowpt Delorme XMat HH Nativeyesyesnowpt Delorme XMat HH Street Atlasyesyesnowri Microsoft Writeyesyesnowri Wordpadyesyesnows Wordstaryesnonows Workspaceyesnonowsa WorksHelpyesnonowsc WorksHelpyesnonowsd Panel sourceyesnonowsdl Web Service Description Languageyesnonowsf WorksHelpyesnonowsp WorksHelpyesnonowsr WorksHelpyesnonowsw WorksHelpyesnonowtb PhotoPlus profileyesnonowtm Visual Studio Workflowyesnonowxc EasyOffice textyesnonowxf MySQL scheduled taskyesnonowxr EasyOffice resourcesyesnonowxs Wix xmlnsyesnonowxt EasyOffice targetyesnonowxu EasyOffice Lexusyesnonoxaml Windows Presentation Foundationyesnonoxar eXtended Markup Languageyesnonoxba LibreOffice moduleyesnonoxbel FreeDesktopyesnonoxbl XML Bindings systemyesnonoxbs Scriptyesnonoxcent XCodeyesnonoxcu LibreOfficeyesnonoxhsd Initialization fileyesnonoxib Interface Builder 3yesnonoxla Microsoft Excel Add-inyesnonoxlb LibreOfficeyesnonoxlc Microsoft Excel Cellyesnonoxliff eXtensible Markup Languageyesnonoxlm Microsoft Excel Macroyesnonoxls Microsoft Excelyesnonoxlsm Excel 2007yesnonoxlsx Excel 2007yesnonoxlt Microsoft Excel Templateyesnonoxltx Microsoft Excel Modelyesnonoxlw Microsoft Excel Workspaceyesnonoxmf 4D resourcesyesnonoxml Garmin Logbookyesnonoxml eXtended Markedup Languageyesnonoxml OpenStreetMap data fileyesnonoxml Garmin Training Centeryesnonoxml4 eXtended Markedup Languageyesnonoxml5 eXtended Markedup Languageyesnonoxp ePiX sourceyesnonoxpf LMMS Project Fileyesnonoxpr Extensible Markup Languageyesnonoxps Ini fileyesnonoxpsf Playlistyesnonoxqr XQueryyesnonoxrc Resourceyesnonoxsd W3C XML Schema Descriptionyesyesnoxsl XML Stylesheetyesnonoxsl_fpac Initialization fileyesnonoxslt Extensible Stylesheet Language Transformationyesnonoxsm Dreamweaver submenu descriptionyesnonoxspf Playlistyesnonoxsx XML Schema Designeryesnonoxt2 XTender2 configuration fileyesnonoxul XML User Interface Languageyesnonoxws Rasterex Workspaceyesnonoy Bison suffix fileyesnonoyaml YAMLyesnonoyml Config scriptyesnonoyml Ruby sourceyesnonoypl Qtrax Media Libraryyesnonoz80 YI89 sourceyesnonozdr Carl Zeiss reportyesnonozed ZTC inputyesnonoznn Zonnon Source Fileyesnonozpdata ZennoLab filter datayesnonozsl ZTC dictionaryyesnono(969 formats)

07-31-2020, 05:17 PM Burt Windows 10 Office 2016 Novice Join Date: Apr 2019 Posts: 24 Any tips on how to migrate 4mb and larger files from Lotus123 to Excel? My Dad is trying to move from Lotus123 to Excel. We have successfully converted some of his Lotus files to Excel using free online converters that are available, but we're having trouble finding any that can handle his biggest files.... one is 4mb and another is 7mb. He cannot get into Lotus anymore to break the files into smaller pieces.Any tips on how to migrate 4mb+ files from Lotus123 to Excel? 07-31-2020, 07:32 PM Logit Windows 10 Office 2007 Expert Join Date: Jan 2017 Posts: 574 Step 1Locate the Lotus .123 file that you wish to open. If it has a “.123” appendage, you need to rename it to have a “.wk4” appendage. This will allow Excel to read the file.Step 2Right click the Lotus 123 (.wk4) file.Select “Open with…” and select Microsoft Excel. Excel will open the file with all associated information and formatting. If you wish to convert to a native Excel file, merely save it, making sure to select the Excel format. 07-31-2020, 07:57 PM Burt Windows 10 Office 2016 Novice Join Date: Apr 2019 Posts: 24 Hi Logit,Thank you for the reply.When I open the file in the manner you suggest, Excel gives the message "This file is not in a recognizable format." It then kicks me into the Text Import Wizard, where I can specify delimiters. This allows me to open the file but what is displayed is not anything meaningful.... just stuff like this:


пяяЂяяАяяя#Т‹PeяяяяпяяЂяяАяяя#ТThanks,Burt 07-31-2020, 08:02 PM Logit Windows 10 Office 2007 Expert Join Date: Jan 2017 Posts: 574 Can you post one of the Lotus files here ? I'd like to see what I can do with it.You are running Excel 2016 and I'm using 2007. I'm curious if my version still has something in it to convert the file. 07-31-2020, 08:10 PM Logit Windows 10 Office 2007 Expert Join Date: Jan 2017 Posts: 574 .Sent you a private message. 07-31-2020, 08:18 PM

Se entregaba con cada ordenador portable Osborne 1.¿Dónde se creó Lotus 123?Su sede central se encontraba en Cambridge, Massachusetts. En el año 1983 presentó el software para computadoras personales Lotus 1-2-3, que llegó a convertirse en el estándar de las hojas de cálculo en los inicios de la computación personal.¿Qué es la Lotus 123?Lotus 1-2-3 fue un programa de hoja de cálculo desarrollado por la hoy desaparecida empresa estadounidense Lotus Development Corporation, que fue adquirida por IBM en 1996. Fue la primera killer application (“aplicación matadora”) para la plataforma IBM PC.¿Qué es Lotus y cuándo nació?Lotus Cars es un fabricante del Reino Unido especializado en automóviles deportivos, con sede en Hethel, Norfolk, creada como Lotus Engineering Ltd por el ingeniero Anthony Colin Bruce Chapman en 1952. En los Años 1960 y 70 participó activamente en las carreras de Fórmula 1.¿Cuándo nace la primera versión de Excel?Microsoft publicó la primera versión de Excel para Mac en 1985, y la primera versión de Windows (numeradas 2-05 en línea con el Mac y con un paquete de tiempo de ejecución de entorno de Windows) en noviembre de 1987.