Dividing Whole Numbers Into Quarters

[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."

 

[Bernie Deitrick]

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

 

[Ron Rosenfeld]

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."

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

=dollarfr(A1,4)


--ron