Export to excel dataformat issue

[sudheer]

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

[Princy]

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:
aspx:

<telerik:GridBoundColumn DataFormatString="&nbsp;{0}&nbsp;" DataField="PhoneNo"></telerik:GridBoundColumn>

Thanks
Princy.