DOLLAR Function in Excel: Syntax, Examples and Free Practice
DOLLAR is an Excel Text function. Converts a number to text using currency format.
DOLLAR syntax
=DOLLAR(number, [decimals])
Arguments
number: A number to use in the calculationdecimals: How many decimal places to use (optional)
When to use DOLLAR
DOLLAR is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice DOLLAR online, free
Open the live Excel-style spreadsheet and try DOLLAR yourself. No Excel install or sign-up needed to start.
Practice DOLLAR now →More Text functions
Frequently asked questions
What does the DOLLAR function do in Excel?
Converts a number to text using currency format.
What is the syntax of DOLLAR in Excel?
The syntax is =DOLLAR(number, [decimals]). number: A number to use in the calculation; decimals: How many decimal places to use (optional).
Where can I practice DOLLAR online for free?
Open the free live spreadsheet on Cellgrids and try DOLLAR yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts