Export to excel dataformat issue

2 posts, 0 answers
  1. sudheer
    sudheer avatar
    109 posts
    Member since:
    Dec 2008

    Posted 07 Apr 2009 Link to this post

    Hi telerik team,

    I have an issue while export grid into excel data format is not working fine
    Ex: in Grid 25.60 in excel 25.6 
    phone Num-         0123456789 in excel 123456789

    while searching in forums i found this URL http://idunno.org/archive/2004/14/01/122.aspx. but no use.

    Thanks for any help
  2. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 08 Apr 2009 Link to this post

    Hello Sudheer,

    Try wrapping the cell contents for the columns that display numeric values with nbsp tags using the DataFormatString property as shown below and see if it helps:
    <telerik:GridBoundColumn DataFormatString="&nbsp;{0}&nbsp;" DataField="PhoneNo"></telerik:GridBoundColumn> 

Back to Top