When i try write a DT to excel, it deletes zeros for only 6 digit numbers. Do you have any idea how to solve this problem

Help Activities
, ,
4

give a try on reformat the cell format by a custom format. We can use following activity to do this:
grafik
grafik

The custom format you can prototype manually in excel

Also have a look here on e.g. the ’ (Apostroph) approach