Text formatting of formula columns for Currency

[D.Stockford (David Stockford)]

Adding Dollar Sign to formula column

I created a formula column and I want to display the dollar sign in the column. I used the text option for the dollar sign but when I did that, only one of my formula columns worked and the other one is showing an error. Is there a way to automatically have the $ present like I can do with the number column? Thanks your help!

this post has a work around that works for me