The DOLLAR function with examples in Excel

 The DOLLAR function in Excel converts a number to text using the currency number format. Here’s how it works:

1. Syntax:

   • DOLLAR(number, decimals)
   • number: The numeric value you want to convert.
   • decimals: The number of digits to display to the right of the decimal point (default is 2).

2. Examples:

   • To format the number 12345 as currency with 2 decimal places and the dollar sign ($), use:

     $$=DOLLAR(12345,2)$$

     (result: $12,345.00).
   • For the value 9876.54 displayed as currency with 1 decimal place and the euro symbol (€), use:

     $$=DOLLAR(9876.54,1)$$

     (result: €9,876.50).

Remember that the DOLLAR function returns text, not a numeric value, so it’s useful for formatting purposes but not for calculations.