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
Question marked as Top-ranking reply

Posted on Jul 13, 2023 1:47 PM

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.


2 replies
Sort By: 
Question marked as Top-ranking reply

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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Display an improper fraction within a custom format.

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