How to Use the DOLLAR Function in Excel
Below is a detailed guide on how the DOLLAR function works in Microsoft Excel and Google Sheets:
Overview
The DOLLAR function is designed to convert a numerical value into a text format, applying a currency symbol, including commas for thousands, and allowing for a specified number of decimal places.
Syntax
The syntax for the DOLLAR function is consistent across both Excel and Google Sheets:
DOLLAR(number, decimals)number: The numeric value you wish to format as text.decimals: [Optional] The desired number of decimal places. If not specified, it defaults to 2.
Examples
Here are some examples to illustrate the use of the DOLLAR function:
| Number | Formula | Result |
|---|---|---|
| 123456.789 | =DOLLAR(123456.789) |
$123,456.79 |
| 98765.4321 | =DOLLAR(98765.4321, 3) |
$98,765.432 |
Use Cases
The DOLLAR function is incredibly useful for presenting numbers as currency in documents where clarity and professional formatting are required. Common applications include:
- Financial statements
- Sales reports
- Invoice templates
This function allows you to easily transform numerical data into formatted currency values, enhancing readability and professionalism in financial documents.
It is important to note that the DOLLAR function simply modifies how a number appears—it does not alter the underlying numerical value itself.
More information: https://support.microsoft.com/en-us/office/dollar-function-a6cd05d9-9740-4ad3-a469-8109d18ff611