Display fraction denominator even if zero

[siamond]

I would like to displays lbs and oz as a fraction, something like "5 4/16". Which is very straightforward (format cell, fraction, as sixteenth).

I cannot understand how to define a custom format which forces the denominator to be displayed though, even it's zero. So that I get "3 0/16" instead of "3".

I tried "# #/16" and a few variations, can't figure it out. Any suggestion?

(yes, I could use a more complex formula based on text formats, but I was hoping there would be something simpler, keeping the resulting value as a number)

 

[RoryA]

Try:
# 0/16

 

[Scott Huish]

On a side note, the number you're looking to display is the numerator, not the denominator.

 

[siamond]

Try:
# 0/16

Why didn't I think of that... Thank you!

 

[siamond]

On a side note, the number you're looking to display is the numerator, not the denominator.

Hm, no, I wanted to display the bottom number, which in a fraction is the denominator. Anyhoo, problem solved!

 

[Scott Huish]

Hm, no, I wanted to display the bottom number, which in a fraction is the denominator. Anyhoo, problem solved!

Yes, that is correct, but you said even if it's 0, that is the top #.