Forums

Decimal values in crm grids Cancel The title field is required!

1. smehdi

   

   40 posts
   Registered:
   23 Mar 2015
   16 Jun 2015

   Link to this post

   Hi,
   In CRM grid controls, numeric columns are showing (in some cases) up to 10 decimal places e.g. 2.0000000000. Not sure where it's reading this from as in CRM we have set decimal precision to 2 (in most cases). Is there a way to correct this?
   Regards,
2. Clinton Bale

   

   126 posts
   Registered:
   21 Feb 2014
   Answered

   17 Jun 2015 in reply to smehdi

   Link to this post

   Hello Shan,
   
   Specify a format string in the column editor in the Format HTML box for that column.
   
   Something like this should ensure only 2 decimal places: {0:F}
   
   If you're looking to format a decimal into a currency: {0:C}
   
   More information on C# format strings can be found here.
   
   Regards,
   Clinton