You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Erased a cell and added new numbers but they dissapear when I select another cell.

Deleted data from a cell. Entered new numbers which disappear when I move to another cell and leaves a #1 at the end of the original cell.

MacBook Pro 15″, macOS 10.13

Posted on Aug 24, 2021 4:39 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 24, 2021 6:36 PM

Solved it. Program was seeing / as a divisor sign, not a divider one. So when I typed in 43/43 I got back 1. Beforehand I'd been using non-rounded numbers like 25.3/30.5 and the Program had left it as is or had entered a result that didn't show up in the space I'd allowed in the cell.

5 replies

Aug 25, 2021 10:04 AM in response to Badunit

You're right. They're actually centiMorgan values in a genealogy Leeds chart (see YouTube) and neophyte that I am I was entering them as described above, then tried to round the numbers in the column, couldn't do that, decided on a fresh start and the next values happened to be rounded 43s and massive brain damage ensued. What I finally ended up using was Space. So 43 43, 220 60 et cetera ad nauseum.

Erased a cell and added new numbers but they dissapear when I select another cell.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.