how do I display pounds in fractions?

  • Thread starter Thread starter DiscoDuck
  • Start date Start date
D

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?
 
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.
 
Back
Top