Part lister to Excel => Cell format issues

For practical reasons I'd prefer generating an Excel file directly, but I have issues since the default formatting in the excel file will treat cells containing things like "0603" like numbers, so removing leading zeroes, as well as for e.g. part numbers which should all be treated as text, and as well not remove any leading zeroes.

So is there any way of fixing this, or is the only way to go through a text file and do conversion in Excel?

Is there a way to modify the way the file is created with vb script? If so, exactly how? or are you referring to inside Excel itself? For the latter, the default formatting would already have discarded the information.