I have a column in my grid for which the underlying database column definition is decimal(18,5). In the grid I have set the Format property to P (also tried p with no difference). When the data is displayed it is correct, so a value of .35 displays as 35.00%. The problem is that when you enter the cell the displayed value changes to .35000. That wouldn't be so bad but if you enter a value of .37 once you leave the cell it displays 0.37% and if you save the data to the database the result is .0037.

Is there a property somewhere that can be changed that will affect this behavior or is this a bug?

 Thanks, Dave