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: 3 Responses to “How Do I Input Fractions In a Numbers Formula Without a Divide Symbol Appearing?”

    2 years 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.

    Peter Paul Mendel
    2 years ago

    How can I create fractions such as 1/64 or 324/13,000 ?

    2 years ago

    Peter: See the comment above yours. There I have a link to a video that shows you how.

Comments Closed.