DOLLAR
The DOLLAR function converts a number to text in currency format with the currency symbol and commas. It is useful for displaying numeric data in financial reports or invoices. The function helps present numbers 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 🔗
Use the DOLLAR function in Excel to convert numeric values into a text representation with a currency format. This function adds the appropriate currency symbol and formats the number for readability in financial documents. The DOLLAR function is useful for creating financial reports, invoices, or budgets. You can also specify the number of decimal places to customize the display according to your needs.
Examples 🔗
To display a numeric value of 12345 as currency with 2 decimal places using the dollar sign ($), use the formula: =DOLLAR(12345, 2)
If you have a numeric value of 9876.54 and wish to present it as currency with 1 decimal place using the euro symbol (€), apply the formula: =DOLLAR(9876.54, 1)
Notes 🔗
Use the DOLLAR function to display numeric data in a currency format. This function is intended for visual presentation, enhancing the readability and professional appearance of your financial documents. It does not perform currency conversion or financial calculations.
Questions 🔗
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.