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.