DOLLARDE Function
Converts a fractional price, like a bond quote in 32nds, into a decimal.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A decimal price
Want to practice DOLLARDE in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
US Treasury bonds are quoted in fractions: 101-03 means 101 and 3/32. DOLLARDE turns that notation — typed as 101.03 — into the decimal 101.09375.
The digits after the point are the numerator; fraction is the denominator.
Syntax
=DOLLARDE(fractional_dollar, fraction) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| fractional_dollar | Yes | The price with the numerator after the decimal point (101.03 = 101 3/32). |
| fraction | Yes | The denominator, e.g. 32 or 16. |
Examples
Example 1 — Treasury quotes to decimals
Northstar's treasury desk receives prices in 32nds and 16ths.
C2fx=DOLLARDE(A2,B2)
| A | B | C | |
|---|---|---|---|
| 1 | Quote | Fraction | Decimal |
| 2 | 101.03 | 32 | 101.09375 |
| 3 | 99.16 | 32 | 99.5 |
| 4 | 1.02 | 16 | 1.125 |
Common mistakes
- #DIV/0! or #NUM!. fraction must be at least 1 (decimals are truncated).
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.