Export Telephone number

[Rhys]

Hi, I have been playing with the Demo RadGrid, and I want to use it to export some data to a spread sheet, the data is already in the db by the time I get to using the RG, and it is there as a string and it displayes the leading 0, i.e. 083 ## ### ##

But when I export it to excel, I get 83####### is there any way to export this to excel so that the leading 0 comes out too?

Thanx

[Daniel]

Hello Rhys,

I answered the same question in another thread:

Leading Zero's - Export to Excel

Let us know if we can assist you further.

Sincerely yours,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Rhys]

Thank you Daniel, just what I need, but where exactly do I drop that line of code.

Thanx

[Daniel]

Hello Rhys,

I recommend you a declarative approach:

<telerik:RadGrid ID="RadGrid1" runat="server" ...>
    <MasterTableView ...>
        <Columns>
            <telerik:GridBoundColumn
                DataFormatString="&nbsp;{0}"
                DataField="yourDataField"
                UniqueName="yourColumnName"
                HeaderText="yourHeaderText">
            </telerik:GridBoundColumn>

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.