Excel import and delimiters

I am exporting a file from Quickbooks to Excel. The customer name and job number are in the same field when imported. I use the text to column feature and it seperates the items, however when it does this any numbers beginning with 0 the 0 goes away in the transfer. Such as Job NO 0404076 comes in as 404076. I need the 0 to stay. What do I do. Thanks