Displaying Formatted Currency Values As Text

Displaying formatted currency values as text
Excel’s DOLLAR function converts a number to text using the currency format. It takes two arguments:
the number to convert, and the number of decimal places to display. The DOLLAR function
uses the regional currency symbol (for example, a $).
You can sometimes use the DOLLAR function in place of the TEXT function. The TEXT function,
however, is much more flexible because it doesn’t limit you to a specific number format. The second
argument for the DOLLAR function specifies the number of decimal places.
The following formula returns Total: $1,287.37.
formula       =”Total: “ & DOLLAR(1287.367, 2)