Leading zeroes


I have a .NET DataGrid and some entries in it look like 0005 (have leading zeroes), when others are just text.

I do:

myCells.Columns[4].Style.Number = 49;//set formatting as text
myCells.ImportDataGrid((DataGrid)myGrid, 0, 0, dataGrid.Items.Count, dataGrid.Columns.Count, false);

After that number in the cell is formatted as text, which is what I need, but leading zeroes are lost- it is 5 instead of 0005

Could you suggest any way to preserve leading zeroes?

Thank you!


Could you please post a screenshot of your DataGrid?