Microsoft Office Tutorials and References
In Depth Information
The DOLLARFR and DOLLARDE functions are useful when working with fractional dollar values, as in stock
Working with feet and inches
A problem that has always plagued Excel users is how to work with measurements that are in feet and inches.
Excel doesn't have any special features to make it easy to work with this type of measurement units, but in some
cases, you can use the DOLLARDE and DOLLARFR functions.
If you enter 5'9" into a cell, Excel interprets as a text string — not five feet, nine inches. But if you enter the value
as 5.09, you can work with it as a value by using the DOLLARDE function. The following formula returns 5.75,
which is the decimal representation of five feet nine inches expressed as fractional feet.
If you don't work with fractional inches, you can even create a custom number format, as shown in column G of
#” ft”. 00” in.”
The worksheet shown here uses a custom number format to display a value that represents feet and inches.
Consider the value $9.25. You can express the decimal part as a fractional value ($9 1/4, $9 2/8, $9 4/16, and so
on). The DOLLARFR function takes two arguments: the dollar amount, and the denominator for the fractional
part. The following formula, for example, returns 9.1 (and is interpreted as “nine and one-quarter”):