Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.