Can TO_DOLLARS format negative numbers and display them differently?

Yes. Negative values display as -$XX.XX by default in most locales. Some regional settings or custom formatting may display negative currency as ($XX.XX) in red or with other visual distinctions. The exact format depends on your spreadsheet locale settings and whether custom number formatting is applied.

What happens when I use TO_DOLLARS with very large numbers or numbers with many decimal places?

TO_DOLLARS formats the number as currency, adding commas as thousands separators and rounding to exactly two decimal places. Very large numbers like 1000000 display as $1,000,000.00. Extremely large numbers beyond 10^15 may lose precision, and numbers with more than two decimal places are rounded to the nearest cent.

Can I use TO_DOLLARS in conditional formatting rules or data validation lists?

TO_DOLLARS returns a text string, which works for displaying formatted values in cells but not for conditional formatting rules that expect numeric comparisons. Use the original numeric value for rules (IF(value > 100)), then format only the display with TO_DOLLARS. Data validation can reference TO_DOLLARS results but won't validate based on currency formatting.

How do I combine TO_DOLLARS with aggregation functions like SUM, AVERAGE, or other calculations?

Nest TO_DOLLARS outside the aggregation function: =TO_DOLLARS(SUM(A1:A10)), =TO_DOLLARS(AVERAGE(B2:B5)), or =TO_DOLLARS(IF(condition,value1,value2)). The inner function computes first, then TO_DOLLARS formats the result as currency. Never put TO_DOLLARS inside the aggregation, as the function expects numeric input.

TO_DOLLARS function

Converts a numeric value to a text string formatted as currency with a dollar sign, commas, and two decimal places for display.

=TO_DOLLARS(value)

Generate a TO_DOLLARS formula

Describe what you need. The generator will reach for TO_DOLLARS where TO_DOLLARS is the right tool, and tell you when it is not.

Arguments

How TO_DOLLARS reads its arguments

Argument	Required	Description
value	Required	A number or numeric expression to format as currency. Empty cells return $0.00. Text that cannot be coerced to a number returns a #VALUE! error.

Returns

A text string formatted as currency with a dollar sign, commas, and two decimal places.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Format a unit price as currency

Unit Price

29.95

=TO_DOLLARS(29.95)

Result: $29.95

TO_DOLLARS takes the numeric value 29.95 and converts it to the text string $29.95, adding a dollar sign and ensuring exactly two decimal places are displayed. This is the most basic use case for formatting any price or monetary value.

2. Format an order total (units × unit price)

Units	Unit Price
5	29.95

=TO_DOLLARS(5*29.95)

Result: $149.75

TO_DOLLARS first evaluates the multiplication expression (5 × 29.95 = 149.75), then formats the resulting number as a currency string. The function handles the calculation and formatting in one step, producing the text output $149.75.

3. Format revenue from East region orders

Order ID	Region	Units	Unit Price
1001	East	5	29.95
1003	East	12	15.5

=TO_DOLLARS((5*29.95)+(12*15.50))

Result: $335.75

TO_DOLLARS handles the multi-step calculation with multiple order totals added together (149.75 + 186.00 = 335.75), formatting the final result as currency. This pattern is essential for regional sales summaries and filtered aggregations across your data.

Common errors

Which TO_DOLLARS error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	TO_DOLLARS attempted to format text that cannot be converted to a number. Example: =TO_DOLLARS("N/A") or =TO_DOLLARS(rep_name) where rep_name contains 'Alice' instead of a numeric value.	Verify the input is numeric or can be coerced to a number. Replace text references with numeric columns (Unit Price, Units, etc.) or convert the text to a number first using VALUE() or a similar function.
#REF!	The formula references a cell or range that no longer exists. Example: =TO_DOLLARS(A1) when column A was deleted or the cell reference points to removed data.	Update the formula to reference a valid cell containing the numeric value. Verify the column still exists and the row contains data. Use absolute references ($A$1) to prevent automatic reference shifts during editing.
#NUM!	The numeric value is too large or outside the acceptable range for currency formatting. Example: =TO_DOLLARS(10^308*10^308) causing numeric overflow or extremely large exponents.	Ensure input values are within a reasonable range (typically -10^15 to 10^15 for currency). Verify calculations don't produce errors before formatting; consider breaking complex calculations into multiple cells to identify the source of extreme values.

Tips and when to use something else

TO_DOLLARS always returns text, not a number. If you need to perform mathematics on the result, keep the original numeric value separate and format only the display cells with TO_DOLLARS.
For formatting percentages instead of currency, use TO_PERCENT. For general text formatting with custom patterns, use TO_TEXT.
TO_DOLLARS respects your spreadsheet's locale settings for currency symbols and formatting conventions, so the same formula displays $ in US locales and other symbols elsewhere.
Combine TO_DOLLARS with conditional formatting on the original numeric values or use IF statements to show currency conditionally: =IF(D2>100,TO_DOLLARS(D2),"-")

Related functions

TO_TEXTConverts a value to text format, returning its content as plain text regardless of the original data type or formatting.TO_PERCENTConverts decimal values to percentage format, displaying numbers like 0.25 as 25% for easy readability in spreadsheets and reports.TO_PURE_NUMBERConverts a value to its pure numeric form, removing formatting like currency, percentage, or text labels to expose the underlying number.SUMSUM adds numeric values in a range or multiple ranges, ignoring text and empty cells, and returns the total sum.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.

Frequently asked questions

Can TO_DOLLARS format negative numbers and display them differently?: Yes. Negative values display as -$XX.XX by default in most locales. Some regional settings or custom formatting may display negative currency as ($XX.XX) in red or with other visual distinctions. The exact format depends on your spreadsheet locale settings and whether custom number formatting is applied.
What happens when I use TO_DOLLARS with very large numbers or numbers with many decimal places?: TO_DOLLARS formats the number as currency, adding commas as thousands separators and rounding to exactly two decimal places. Very large numbers like 1000000 display as $1,000,000.00. Extremely large numbers beyond 10^15 may lose precision, and numbers with more than two decimal places are rounded to the nearest cent.
Can I use TO_DOLLARS in conditional formatting rules or data validation lists?: TO_DOLLARS returns a text string, which works for displaying formatted values in cells but not for conditional formatting rules that expect numeric comparisons. Use the original numeric value for rules (IF(value > 100)), then format only the display with TO_DOLLARS. Data validation can reference TO_DOLLARS results but won't validate based on currency formatting.
How do I combine TO_DOLLARS with aggregation functions like SUM, AVERAGE, or other calculations?: Nest TO_DOLLARS outside the aggregation function: =TO_DOLLARS(SUM(A1:A10)), =TO_DOLLARS(AVERAGE(B2:B5)), or =TO_DOLLARS(IF(condition,value1,value2)). The inner function computes first, then TO_DOLLARS formats the result as currency. Never put TO_DOLLARS inside the aggregation, as the function expects numeric input.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17