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.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.