Apple Intelligence is now available on iPhone, iPad, and Mac!
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
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.
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.
My first guess is the cell has a custom format in it that puts "#1" in the cell if the value meets a rule in the format. Take a look at the format for that cell.
Another thing to look at while the cell is selected is the bottom left corner of the Numbers window. It should say "actual" and have the number you typed into the cell.
If you want to enter values such as 43/43 and have them stay that way, format the cells as text before entering the data. Or you can enter it as '43/43. The leading apostrophe tells Numbers the data is text and it will format the cell as text. I am assuming you are not using these values in any math formulas.
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.
Try setting the cells' Data format to 'Text' before entering the 43/43 (or other value) in those cells.
REgards,
Barry
Erased a cell and added new numbers but they dissapear when I select another cell.
