Dividing Whole Numbers Into Quarters

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Is there a way to format whole numbers such that decimal
fractions are displayed as quarters, rather than the usual
tenths?

For example, 1/4 would be displayed as ".1," 1/2 as ".2"
and 3/4 as ".3."
 
Mike,

Not through formatting, but you can use a formula. For a number in
cell A1:

=INT(A1)& "."&INT((A1-INT(A1))*4)

This will return a string, so you;ll have to do any math using the
original number in cell A1.

HTH,
Bernie
MS Excel MVP
 
Is there a way to format whole numbers such that decimal
fractions are displayed as quarters, rather than the usual
tenths?

For example, 1/4 would be displayed as ".1," 1/2 as ".2"
and 3/4 as ".3."
Click to expand...

Not with formatting, but if you have the analysis toolpak installed, then:

=dollarfr(A1,4)


--ron
 
Back
Top