The DOLLAR function in Excel is a useful tool for converting a number into text with a currency format. It is particularly handy when you want to display financial data in a more user-friendly manner, such as adding currency symbols and decimal points.
Syntax
DOLLAR(number, [decimals])
Arguments
| number | The numeric value you want to convert to currency format. |
| [decimals] | (Optional) The number of decimal places you want to display. If omitted, it defaults to 2. |
How to Use
To use the DOLLAR function, follow this simple syntax:
|
1 |
DOLLAR(A1, 2) |
This formula will convert the number in cell A1 to a currency format with 2 decimal places. Here are some examples:
|
1 2 3 |
DOLLAR(1234.567) = $1,234.57 DOLLAR(500) = $500.00 DOLLAR(42.1, 1) = $42.1 |
Here’s a breakdown of each example:
1. The DOLLAR function converts 1234.567 to $1,234.57 with 2 decimal places.
2. When applied to 500, it formats it as $500.00 with 2 decimal places (the default).
3. With 42.1 and a specified 1 decimal place, it results in $42.1.
The DOLLAR function is a simple and effective way to format your numeric data as currency, making it more visually appealing and easier to understand.