Leading Zero's - Export to Excel

[Tony]

Hi I need to export data via the radgrid to excel - problem is the key field is a ten digit number which the first six is the patient date of birth ...

Problem is when excel opens with the export the leading zero is missing therefore no longer the patient number

example before export - number 0101071111 
                        after export - number 101071111

Any ideas?

[Daniel]

Hello Tony,

Wrap the cell contents with nbsp tags:

ItemDataBound:

foreach (GridTableCell gcell in e.Item.Cells)
    gcell.Text = String.Format(" {0}", gcell.Text);

aspx:

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

Regards,
Daniel
the Telerik team

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

[Tony]

Many Thanks Daniel - Thats just what the doctor ordered.

Tony

[Peter Milchev]

Hello,

We are sharing another possible approach and also attaching a sample project implementing it. 

The column format can be specified by setting the DataFormatString property to {0:@}, where the @ sign will indicate that the value is of type text.

<telerik:GridBoundColumn UniqueName="InvNo" DataField="InvNo" HeaderText="Inv No." ShowFilterIcon="false" AllowFiltering="false" AutoPostBackOnFilter="true" DataFormatString="{0:@}">

Regards,
Peter Milchev
Progress Telerik