Might be quite a simple question, I have bound a XamDataGrid to a SQL Server view, one field is a quantity, stored as a decimal in the DB. When the Grid displays it, its default format is to show this decimal value as currency, but we only need it to show a decimal value without leading currency symbol.
Having spent all day in FieldLayouts, FieldLayoutSettings and FieldSettings I'm still none the wiser.
Any help greatly appreciated, thanks!
it would seem decimal data types are displayed in the xamcurrencyeditor, and double data type displayed in xamnumbereditor.
Just convert your decimal data to double, and it gets rid of the currencies.