I'm trying to format a column to currency on a SQL report.

I need to allow for up to 4 places right of the decimal. (i.e. $5.1234)

Most of the time I will not have 4 places to the right of the decimal and don't want to see this if the user enters 1 dollar (i.e. $1.0000)

How do i make it so that it would display one dollar as ($1.00 not $1.0000) and display 5.2341 as ($5.2341)

Pretty much, if it has 2 decimal places or none at all than display 2 zeros and if it has more than only show what it needs up to 4 places to the right of the decimal.