I need to export a numeric field (TAX ID) from vb.net to Excel. The value gets converted to Numeric in Excel and leading zeroes are lost. I tried to use code posted on this site. But the style defined here does not get applied in Excel. Following is the sample code.

Any suggestions on how to keep the text "02345" in the same format in Excel?

>>>>>>>>>>>>>>> >>>>>...