Integer formatting in excel

[ppr (Peter Preuss)]

have a look here for reformatings

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

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