# Google Sheets TO_DOLLARS Function: Syntax, Examples & Tips

- URL: https://betteranalyst.com/google-sheets/todollars-function
- Author: Better Analyst

Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation.

[Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst)

Converts a number to a value formatted as currency (dollars).

```
=TO_DOLLARS(value)
```

Generate FormulaExplain Formula

One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.

Describe the TO\_DOLLARS you need in plain EnglishGenerate Formula

## Parameters

| Parameter | Required | Description |
| - | - | - |
| **value** | Yes | The number, or reference to a cell containing a number, to format as currency. Non-numeric values are returned unchanged. |

## 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](https://betteranalyst.com/google-sheets/topercent-function), [TO\_DATE](https://betteranalyst.com/google-sheets/todate-function), [TO\_TEXT](https://betteranalyst.com/google-sheets/totext-function) and [TO\_PURE\_NUMBER](https://betteranalyst.com/google-sheets/topurenumber-function).

## 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

| Function | Returns | Can do maths on it? |
| - | - | - |
| TO\_DOLLARS | A number with currency formatting | Yes |
| DOLLAR | Text such as "$1,500.00" | Not directly |
| TEXT(value, "$#,##0.00") | Text in a custom format | Not directly |

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](https://betteranalyst.com/google-sheets/topercent-function), [TO\_TEXT](https://betteranalyst.com/google-sheets/totext-function), [TO\_PURE\_NUMBER](https://betteranalyst.com/google-sheets/topurenumber-function), [TO\_DATE](https://betteranalyst.com/google-sheets/todate-function), DOLLAR, TEXT, and GOOGLEFINANCE.

## Example use case

A sales ops analyst builds a summary table with =QUERY(Data!A:D, "select A, sum(D) group by A"). The totals arrive as plain numbers, so she wraps the summed column in TO\_DOLLARS via a helper column so the dashboard always shows currency, even when the query results shift.

## Need more help with Google Sheets formulas?

Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis.

[Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai)

## Google Sheets how-to guides

- [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets)
- [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets)
- [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets)
- [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets)
- [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file)
- [How To Remove Blank Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-blank-rows-in-google-sheets)
- [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets)
- [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets)

## Explore all Google Sheets formulas

Browse our complete library of Google Sheets formula guides

Compare your options

## Decide with evidence, not a sales pitch.

Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.

1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.)
2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.)
3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.)

AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.