MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Input Fractions In a Numbers Formula Without a Divide Symbol Appearing?

Trying to create a formula in a cell which needs to have “1/96”, however, Numbers converts the “/” to a “➗” symbol. How can I avoid this? I tried going to Numbers > Preferences > Auto Correction > toggling Automatically Format Fractions on and off.

When required to enter a specific formula, Microsoft Excel allows the ability to use “/” to utilize a fraction, however, Apple Numbers does not. Fractions in this particular formal seem to be required.
—–
Eric

Comments: One Response to “How Do I Input Fractions In a Numbers Formula Without a Divide Symbol Appearing?”

    1 month ago

    You you'd need to do is to use the Fractions format for the cell. You can get to it by selecting the cell(s) and choosing Format, Cell in the sidebar and then set the Data Format to Fraction.

    Now you should be able to type something like 1/96 and you'll see 1/96 in the cell.

    See https://macmost.com/10-useful-numbers-cell-formatting-examples.html for an example. It is the last one at the end of the video.

Leave a New Comment Related to "How Do I Input Fractions In a Numbers Formula Without a Divide Symbol Appearing?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)