If the problem is with Excel, I will just not worry if I preview the file in Excel. My process is DTS to a .csv and then automatically scheduling...

I have this same issue in exporting zip codes to a .csv file. I need the first 5 from the left, including the 0. This code works beautifully...