I am currently working on trying to figure out why Custom formatting gets lost when exporting to excel. We use the following formatting:

aBand.Columns[OrderKeys.ContractValue].Format = "C";
aBand.Columns[OrderKeys.CancelDate].Format = "MM/dd/yyyy"; 

When we export to excel we don't get those columns in the date format or currency format. They are exported with the General Format in excel. The user has to manually change the column in excel to the expected cell format. Has anyone run into this problem before? Can it be fixed in code before I export?

 thanks   -Ken