DOLLAR

The DOLLAR function converts a number to text using the currency format, with the appropriate currency symbol and commas where necessary. This function is useful for displaying numeric data in financial reports or invoices in a clear and readable format.

Syntax

=DOLLAR(number, decimals)

number The numeric value you want to convert to text.
decimals The number of decimal places to display in the converted text. Defaults to 2 if omitted.

About DOLLAR

When you're dealing with numerical data in Excel and need to present it in a currency format, the DOLLAR function comes to the rescue. It simplifies the process of converting numeric values into text representation, complete with the appropriate currency symbol and proper formatting for easy readability in financial documents or presentations. Whether you're creating financial reports, invoices, or budgets, DOLLAR ensures that your numbers are displayed with precision and clarity in a currency-style format. The ability to specify the number of decimal places enhances the customization options, allowing you to tailor the display to meet your specific formatting requirements.

Examples

If you have a numeric value of 12345 and you want to display it as currency with 2 decimal places using the dollar sign ($), the DOLLAR formula would be: =DOLLAR(12345, 2)

For a numeric value of 9876.54 that you want to present as currency with 1 decimal place using the euro symbol (€), you would use the formula: =DOLLAR(9876.54, 1)

Questions

Can I customize the currency symbol used with the DOLLAR function?

Yes, you can specify any currency symbol or character you prefer by incorporating it into the format of the converted text within the DOLLAR function. Simply include the desired symbol within quotation marks as part of the formula.

Is there a limit to the number of decimal places that can be displayed with the DOLLAR function?

The DOLLAR function allows you to specify up to 30 decimal places for displaying precise numerical values. However, keep in mind that excessive decimal places may not always be necessary for clear financial representation and could impact readability.

Does the DOLLAR function handle negative numbers differently?

The DOLLAR function treats negative numbers similarly to positive numbers when converting them to text in currency format. The function includes the appropriate currency symbol and format while representing the numerical value with the specified decimal places.

Related functions

TEXT