How to display currency symbol in grid?

tdickens

Is it possible to display the currency symbol (dollar sign) in a grid?  Or even an Edit box?

What I want is for the grid to show the price with a dollar sign.  Like this: $12.34.  Instead of this: 12.34.

I've looked at all of the properties on a grid column.  I don't see a way to set a grid column to show the dollar sign.  The Input Mask doesn't allow a dollar sign.  

I also looked at the IDO.  I set the Data Type to Currency.  But that doesn't make a grid column show a dollar sign.

Thanks for your help.

Caitlin Porter

As far as I know, you cannot add a dollar sign to the grid using standard mongoose toolset. However, I did find a workaround that seems to work. You could create a derived field that adds a dollar sign to the beginning, the implementation would look something like this: 

'$' + CAST(CustomerWorth AS NVARCHAR)