Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

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.

Comments 4 CommentsJump to latest comment

reecardo's picture

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

SOLUTION
Aryanos's picture

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

Aryanos's picture

Thanks to reecardo I got this to work using a C# script.

I like my beats fast and my bass down low

rhamner's picture

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.