Decimal Format in Grid Column
Created: 28 Jan 2013 | Updated: 07 Feb 2013 | 4 comments
This issue has been solved. See solution.
Does anyone know how to set the format in a grid column for a decimal to only show two decimal places? I have a data being returned that shows four decimal places and I need to cut it to two.
Discussion Filed Under:
Comments 4 Comments • Jump to latest comment
You could try using a "Masked Edit" type column and specify a custom mask. The custom mask should resemble something like ######.##.
See the Digit Placeholder section on this page for more info: http://msdn.microsoft.com/en-us/library/0c899ak8.aspx
Sorry for the late reply reecardo. I tried adding the mask to the column using #####.## and #.## and a few other combinations but it's not working. I'll try a few more but there might be something else that it needs.
I like my beats fast and my bass down low
Thanks to reecardo I got this to work using a C# script.
I like my beats fast and my bass down low
I know this is already solved but i was just responding to another post similar to this. For future refrerence, just add 0.## to the format field of the column in the grid editor.
Would you like to reply?
Login or Register to post your comment.