Google Sheets TO_DOLLARS Function: Syntax, Examples & Tips

What Is TO_DOLLARS?

TO_DOLLARS takes a number and returns it with a dollar currency format applied. The underlying value doesn't change — 1234.5 is still 1234.5 — but the result displays like $1,234.50. It is one of a small set of Google Sheets functions that apply formatting from within a formula, alongside TO_PERCENT, TO_DATE, TO_TEXT and TO_PURE_NUMBER.

Why Use a Function for Formatting?

Normally you'd use Format → Number → Currency. TO_DOLLARS is useful when:

• The formula's output lands in a cell whose formatting you don't control, such as an array spilled by QUERY or ARRAYFORMULA.
• You want the currency display to travel with the result regardless of where the formula is copied.
• You are building a value inside a larger formula and want it treated as currency.

Basic Examples

Format a number as dollars

=TO_DOLLARS(1500)

Displays $1,500.00.

Format a calculation

=TO_DOLLARS(B2 * C2)

Displays price × quantity as currency.

Format a whole column

=ARRAYFORMULA(TO_DOLLARS(B2:B100))

How TO_DOLLARS Behaves

• It's still a number. You can add, average or chart the result just like the original value. =TO_DOLLARS(10) + 5 returns 15.
• Non-numbers pass through. If the value is text that isn't a number, TO_DOLLARS returns it unchanged rather than raising an error.
• The currency is the dollar. TO_DOLLARS applies a dollar format; it does not perform any exchange-rate conversion. For live exchange rates use GOOGLEFINANCE with a currency pair, e.g. =GOOGLEFINANCE("CURRENCY:EURUSD").
• Rounding is display-only. The value keeps its full precision; only two decimal places are shown. Use ROUND if you need the stored value rounded to cents.

TO_DOLLARS vs. DOLLAR vs. TEXT

Use TO_DOLLARS when the result needs to stay numeric. Use DOLLAR or TEXT when you're joining the amount into a sentence, such as ="Total due: "&DOLLAR(B10).

Common Use Cases

• Dashboards built from QUERY or FILTER output where cell formatting is lost.
• Calculated columns in templates that must always display as currency.
• Summaries returned by array formulas in reports.

Common Errors

• Expecting currency conversion: TO_DOLLARS does not convert euros or pounds into dollars; it only changes the display.
• Joining with text shows no format: ="Total: "&TO_DOLLARS(B10) returns "Total: 1500" because concatenation uses the raw number. Use DOLLAR or TEXT for that.
• Rounding surprises: A sum of displayed values may look off by a cent because hidden decimals are retained. Round at the line level if that matters.

Tips and Best Practices

• When you control the cell, applying a regular currency format is simpler; reach for TO_DOLLARS when formatting is lost or must be enforced by the formula.
• Use ROUND(value, 2) inside TO_DOLLARS when stored values need to be cent-accurate.
• For other currencies, use a custom number format or TEXT with the appropriate symbol.

Related Functions

TO_PERCENT, TO_TEXT, TO_PURE_NUMBER, TO_DATE, DOLLAR, TEXT, and GOOGLEFINANCE.