As long as it's a NUMBER field you are reporting on, just highlight the field in the DETAIL and click on the CURRENCY tool "$" in the Expert Tools Bar.
If you want to use a formula, you will have to convert the number into a string use this formula
"$" + ToText({TABLE.NUMBERfield })