Using Excel template, is there a way to maintain 0s in the output that are at the beginning of a num

So I am creating an inventory report and there's a column for part numbers.. Part numbers could be all numbers, all letters, a combination of both, could have special characters, spaces etc.

For example here's a possible list of part numbers that could be in the XML.

12345

ABC-123

sjs213ja sp

0000123

00542

00abc

Now excel outputs this information, everything seems fine but the numbers that start with 0 change(i.e. 123 and 542, the 0s in the front are gone) for obvious reasons. But I want them to remain the way they are. Any suggestions?