Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
DOLLAR
DOLLAR formats a number as a text string with a dollar sign prefix, comma thousands separators, and a specified number of decimal places (defaulting to 2). It is used when you need to display monetary values as text — for example, when building concatenated strings or labels that include prices.
Excel
=DOLLAR(A2,2)Google Sheets
=DOLLAR(A2,2)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Enter the numeric values you want to format as currency in column A (e.g., 1234.5 in A2).
- 2Enter =DOLLAR(A2,2) to produce the text string '$1,234.50'.
- 3Change the second argument to control decimal places: =DOLLAR(A2,0) gives '$1,235' with no decimals.
Need a version for your data?
Try: “Format a list of prices as dollar amounts with two decimal places for a report”