DOLLAR function

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.


DOLLAR(number, [decimals])


numberThe 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:

This formula will convert the number in cell A1 to a currency format with 2 decimal places. Here are some examples:

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.