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.

Obelus vs. Slash in Numbers

I find that the obelus (÷) sign is difficult to visually distinguish from the plus (+) sign in Numbers, and would prefer that Numbers displays division using the slash (/) sign.

How do I elect this?

MacBook Pro

Posted on Nov 27, 2020 11:39 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 28, 2020 6:20 PM

Agreed, and my sympathies are in the same direction.


Logically, though, there are two factors that should lower the difficulty, especially if you are the one writing the formula.

  • it's often not difficult to figure our which operation should be performed at a specific location in a formula, given some idea of what the formula is to do and how you'd go about it when working it manually.
  • Given the location of the + and / keystrokes (on the North American English keyboard layout), there is some difficulty in typing the wrong one while writing a formula.


As for reading the ÷ versus the + in the Formula Editor, you could keep a hand held magnifier handy, or use option-command-8 to enlarge the screen image (including the Formula Editor AND its contents. That's also useful when checking that you've not entered a period for a comma (or vice versa).


Meantime, several users Providing Numbers Feedback, asking for user ability to alter the size of the Formula Editor and of type in that editor, might produce a change in Numbers' behaviour.


Regards,

Barry

3 replies
Question marked as Top-ranking reply

Nov 28, 2020 6:20 PM in response to Badunit

Agreed, and my sympathies are in the same direction.


Logically, though, there are two factors that should lower the difficulty, especially if you are the one writing the formula.

  • it's often not difficult to figure our which operation should be performed at a specific location in a formula, given some idea of what the formula is to do and how you'd go about it when working it manually.
  • Given the location of the + and / keystrokes (on the North American English keyboard layout), there is some difficulty in typing the wrong one while writing a formula.


As for reading the ÷ versus the + in the Formula Editor, you could keep a hand held magnifier handy, or use option-command-8 to enlarge the screen image (including the Formula Editor AND its contents. That's also useful when checking that you've not entered a period for a comma (or vice versa).


Meantime, several users Providing Numbers Feedback, asking for user ability to alter the size of the Formula Editor and of type in that editor, might produce a change in Numbers' behaviour.


Regards,

Barry

Nov 28, 2020 12:41 AM in response to ulrich_b

"How do I elect this?"


By using a much older version of Numbers.


Versions after Numbers '09 automatically convert the 'traditional' arithmetic operators /, * and - to the corresponding arithmetical signs ÷, × and -


Or by entering the slash into a cell as text (not part of a formula).


Your issues with this behaviour, particularly with w / vs ÷ part, are shared by many others, although posts regarding it have slowed significantly since early days after the substitution started.


So far there's no user accessible switch to turn the substitution off.


You could use the Provide Numbers Feedback item in the Numbers menu to report your dissatisfaction and request a feature enhancement providing a means of shutting off the substitution of these symbols.


Regards,

Barry

Obelus vs. Slash in Numbers

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