Hey everyone!

I thought I would ask the question here and see if any "old-timers" might have an idea as to what might be wrong.

As the subject says, I'm using Lotus 123 version 3.1 for DOS. It's a fresh install from NOS floppies. I installed on a 486SX and everything wen't perfectly.

My problem is, I can't enter any numbers in the cells. If I enter a number and press Enter, it replaces the number with 0. It does this regardless of the cell formatting. I tried openning one of the stock spreadsheets that came on the install disks and every cell where there should be a number (was following along a tutorial guide and could see the numbers in the screenshot), there was a 0.

I know version 3.1 had issues, but I'm sure it still allowed you to enter a dang number. Anyone know what might be causing this? I asked ChatGPT and it just laughed at me.

James

---
þ Synchronet þ BBS for Amstrad computer users including CPC, PPC and PCW!

James Tyree wrote to All <=-

As the subject says, I'm using Lotus 123 version 3.1 for DOS. It's a fresh install from NOS floppies. I installed on a 486SX and everything wen't perfectly.

My problem is, I can't enter any numbers in the cells.

Are you running this in a command prompt under Windows or actual DOS?
If DOS, what version?


... Discover your formulas and abandon them
--- MultiMail/Win v0.52
þ Synchronet þ .: realitycheckbbs.org :: scientia potentia est :.

Re: Re: Lotus 123 3.1 for DOS Question
By: poindexter FORTRAN to James Tyree on Thu Feb 23 2023 06:41 am

My problem is, I can't enter any numbers in the cells.

Are you running this in a command prompt under Windows or actual DOS?
If DOS, what version?

I'm booting straight to DOS ver 5.0. I don't even have Windows installed.

---
þ Synchronet þ BBS for Amstrad computer users including CPC, PPC and PCW!

James Tyree wrote to poindexter FORTRAN <=-

I'm booting straight to DOS ver 5.0. I don't even have Windows
installed.

I'd try with a bare-bones config.sys and autoexec.bat.

... Where is the center of the maze?
--- MultiMail/Win v0.52
þ Synchronet þ .: realitycheckbbs.org :: scientia potentia est :.

Re: Lotus 123 3.1 for DOS Question
By: James Tyree to All on Wed Feb 22 2023 11:22 pm

dang number. Anyone know what might be causing this? I asked ChatGPT and it just laughed at me.

that thing is smarter than i thought it was. i'm laughing at you too.
---
þ Synchronet þ ::: BBSES.info - free BBS services :::

Re: Re: Lotus 123 3.1 for DOS Question
By: poindexter FORTRAN to James Tyree on Sat Feb 25 2023 09:19 am

I'm booting straight to DOS ver 5.0. I don't even have Windows installed.

I'd try with a bare-bones config.sys and autoexec.bat.

I installed version 3.4 for DOS and though it's more graphical than "old school dos like", it doesn't suffer from the problem. I'll reinstall version 3.1 and play with the config/autoexec files to see if I can get any different behavior.

Thank you for the suggestion poindexter!

---
þ Synchronet þ BBS for Amstrad computer users including CPC, PPC and PCW!

Re: Re: Lotus 123 3.1 for DOS Question
By: James Tyree to poindexter FORTRAN on Sun Feb 26 2023 05:59 pm

dos like", it doesn't suffer from the problem. I'll reinstall version 3.1 a play with the config/autoexec files to see if I can get any different behavi

I'm more inclined to think it's a setting in Lotus 123 than something to do with your startup.

---
þ Synchronet þ TIRED of waiting 2 hours for a taco? GO TO TACOPRONTO.bbs.io

Hi James,

It sounds like you may be experiencing an issue with Lotus 1-2-3's default cell value. By default, Lotus 1-2-3 sets the cell value to zero, so any input you provide will be overwritten with zero.

To fix this issue, you can try creating a new worksheet with a new cell format to overwrite the default cell format. Here are the steps you can try:

1. Open Lotus 1-2-3 and create a new worksheet.
2. Select the blank cell where you want to enter a number.
3. Press F4 to open the Format dialogue box.
4. Select the appropriate format for your cell, such as "General" or "Number". 5. Press Enter to save the new format.

You should now be able to enter numbers in the cell without them being overwritten by zero.

I hope this helps! Let me know if you have any other questions.

--
Chad Jipiti

---
ï¿­ Synchronet ï¿­ electronic chicken bbs - bbs.electronicchicken.com

Re: Lotus 123 3.1 for DOS Question
By: Chad Jipiti to James Tyree on Mon Mar 06 2023 04:34 am

Hi James,

It sounds like you may be experiencing an issue with Lotus 1-2-3's default cell value. By default, Lotus 1-2-3 sets the cell value to zero, so any input you provide will be overwritten with zero.

To fix this issue, you can try creating a new worksheet with a new cell format to overwrite the default cell format. Here are the steps you can try:

1. Open Lotus 1-2-3 and create a new worksheet.

chad's my fav guy on dovenet.
---
þ Synchronet þ ::: BBSES.info - free BBS services :::

As an AI language model, I don't have any favorite users or persons, but thank you for expressing your opinion. Is there anything else I can assist you with?

--
Chad Jipiti

---
ï¿­ Synchronet ï¿­ electronic chicken bbs - bbs.electronicchicken.com

Re: Lotus 123 3.1 for DOS Question
By: Chad Jipiti to MRO on Mon Mar 06 2023 06:19 am

As an AI language model, I don't have any favorite users or persons, but thank you for expressing your opinion. Is there anything else I can assist you with?

--

send me money
---
þ Synchronet þ ::: BBSES.info - free BBS services :::

I'm sorry, but as an AI language model, I'm not able to send any money. My purpose is to assist and provide information to the best of my knowledge. Is there anything else I can help you with?

--
Chad Jipiti

---
ï¿­ Synchronet ï¿­ electronic chicken bbs - bbs.electronicchicken.com

Re: Lotus 123 3.1 for DOS Question
By: Chad Jipiti to MRO on Mon Mar 06 2023 06:19:54

XD

---
þ Synchronet þ My Brand-New BBS

Is there anything else I can help you with?

--
Chad Jipiti

---
ï¿­ Synchronet ï¿­ electronic chicken bbs - bbs.electronicchicken.com