Display an improper fraction within a custom format.

Question

Level 1

4 points

Display an improper fraction within a custom format.

I'd like to format improper fractions within a custom format. The "fractions" has most the intended behavior, but I need to tweak it a little bit, to display the inches symbol (") after the fraction.

I see I can change the .## to display as a fraction so 6.5 becomes 6 1/2". I can then display only the fractional portion when it is less than 1 so 0.5 becomes 1/2" not 0 1/2".

However, when the value is an integer I have an issue, 6 displays as 6 0" instead of 6". This is not the behavior of the "fractions" format, and it's certainly a confusing way to display the info since its easy to confuse with 60".

Is there a way to not display the fractional bit when the number is an integer?

Posted on Jul 13, 2023 1:16 PM

Reply

Answer 1

Top-ranking reply

jaxjason

Level 5

5,047 points

Jul 13, 2023 1:47 PM in response to Ikucw

tested this and yeah 6" even looks exactly like it says 60".

The only thing I can think of is sometimes when I was doing CAD work many many moons ago, we placed a hyphen between whole and fractions. so it would be 6 - 0". (some old software did this type of thing too)

otherwise I dont see a way of fixing that.

I would suggest posting a note to apple numbers feedback site about this oversight.

Feedback - Numbers - Apple

It should have the same option as the whole numbers where it will show a space for a zero, not 0 itself.

Reply

Answer 2

Badunit

Level 7

28,024 points

Jul 13, 2023 2:37 PM in response to Ikucw

You may be overthinking it. This works for me:

Reply

Display an improper fraction within a custom format.

Similar questions