Currency column issue

I have some columns for displaying currency. Some are editable, some are not. The users want decimal places to 5 places but beyond the first 2 places they only want to see significant places.

For example,
2 should show as 2.00
2.5 should show as 2.50
2.55 should show as 2.55
2.55100 instead should show as 2.551

Can I achieve this combining a currency column with a mask?

I do not know how you can do this with a CurrencyEdit cell. But it is simple to do with a standard TextBox cell with a numerical CellValueType and a properly set Format string.

this.gridControl1[4,4].CellValueType = typeof(decimal);
this.gridControl1[4,4].Format = "$0.00###";

Clay,

Thanks, I''d stumbled on this approach yesterday, I appreciate your response though!


>I do not know how you can do this with a CurrencyEdit cell. But it is simple to do with a standard TextBox cell with a numerical CellValueType and a properly set Format string.

this.gridControl1[4,4].CellValueType = typeof(decimal);
this.gridControl1[4,4].Format = "$0.00###";