[Solved] CSV formatting

[Jols]

Good day to all,

                        i have a question about formatting the values of a column when exporting to CSV format..coz i have a column which start at zero its look like this 000001 when i  view the exported data its shows only 1 the zero is omitted how can format that column to retain it..and where do i find the csvcellformatting..please help

thanks a lot

[Princy]

Hello Jols,

You can try wrapping the cell contents with nbsp tags by setting the DataFormatString for the column as shown below so that the content can be exported as such:

aspx:

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

Thanks
Princy.