Excel Cell Format

[Hamed]

Hello,

I have a cell in my grid with value 004. When I export this gridview to Excel, the report lose this formatting and just show 4 in the excel cell.what shoud i do to save format of numbers in excel cell format?

Someone can help me?

Thx
Hamed

[Princy]

Hello Hamed,

Try setting DataFormatString for the column as shown below and see whether it is working fine.

ASPX:

<telerik:GridBoundColumn DataField="Code" UniqueName="Code" DataFormatString=" {0} "  >
</telerik:GridBoundColumn>

Thanks,
Princy.