Formulas > =DOLLAR()
How to Use DOLLAR() in Google Sheets
Description
How To Actually Use DOLLAR() in Sheets
DOLLAR(number, [number_of_places])
Try DOLLAR yourself
In cells A1:A10, use the DOLLAR formula to format the numbers as currency with 2 decimal places. The result should be displayed in the corresponding cells in B1:B10.
Hints (2)
-
Remember to reference the cell containing the number you want to format.
-
Set the number_of_places to 2 for cents.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the DOLLAR() formula:
Generate a DOLLAR() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses DOLLAR(). 2 free AI generations, no signup. Members get unlimited use.
Generate a DOLLAR() formula