how do I display pounds in fractions?

[DiscoDuck]

For instance "1/4 lbs" fraction pounds format

a David Sauder brilliantly suggested the folling in an earlier post"

Select the cells you want to format
Click on format in the menu
Select Cells, and then the Number tab.
Under "Category", pick "Custom"
In the "Type" box, enter something like this:

#,###.00 " lbs"; -#,###.00 " lbs"; 0 " lbs"


This works for a decimal, but how do I get it to display a fraction?

 

[J.E. McGimpsey]

One way:

#,### ?/?" lbs";-#,### ?/?" lbs";0 _0_/_0" lbs"

If you always want 1/4 lbs, use

#,### ?/4" lbs";-#,### ?/4" lbs";0 _0_/_0" lbs"


the _0_/_0

uses the fact the underscore character tells the display engine to
display a space the width of the following character. This allows
the 0 to line up with the other values.

 

[DiscoDuck]

Brilliant. Freaken brilliant. Thank you.