RadGrid number formatting

[Alex Yung]

Dear Telerik Support Team,

I have some decimal number on one column, but when it is smaller than 1 (such as 0.014836583), the display value in the RadGrid is .014836583. How can I format it? I have try DataFormatString, but it fails.

Any help is highly appreciated!

Regards,
Alex

[Missing User]

Hello Alex,



To see more information on the requested functionality, please refer to the following online demo:

• Column formatting

Regards,
Plamen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Alex Yung]

Dear Plamen ,

Thanks for your reply. However, the link provided does not show me how to show the leading zero.

Regards,
Alex

[Missing User]

Hello Alex,

Float numbers between zero and one can be formatted in two ways, with or without leading zero before decimal point. To format number without a leading zero use # before point. For example „#.0“ formats number to have one decimal place and zero to N digits before decimal point (e.g. „.5“ or „123.5“).

Following code shows how can be formatted a zero (of double type).

String.Format("{0:0.0}", 0.0);            // "0.0"
String.Format("{0:0.#}", 0.0);            // "0"
String.Format("{0:#.0}", 0.0);            // ".0"
String.Format("{0:#.#}", 0.0);            // ""

Greetings,
Plamen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Alex Yung]

Hi Plamen,

You mean I should use string in the RadGrid? When I apply the style into DataFormatString in RadGrid, it cannot work.

Thanks,
Alex

[Princy]

Hello Alex,

You can try setting the DataFormatString in the code behind as shown below.
cs:

   GridBoundColumn col = RadGrid1.Columns.FindByUniqueName("Age") as GridBoundColumn;

    // access the cell value
      col.DataFormatString = string.Format("{0:#.###}", value);

Thanks
Princy.

[Alex Yung]

Hi Princy,

This must be set in program? I want to apply this in Design Time when I define every column. When I set {0:0.###} to DataFormatString at the design view, it just dun work. Any idea?

Thanks,
Alex