XML into Excel - leading zero

programming
1

i have an XML file with both strings & numbers such as (part of the XML):


<CarMake>Ford</CarMake>
<CarModel>Focus</CarModel>
<CarYear>06</CarYear>

Now, when taking the file and open it with Excel, it reads the CarYear as an Integer and shows just 6 instead of 06…how do I get the year to be shown as a string as well?

Something to do with XML Schema’s, but I’m not sure how this is done for just a single tag to display as a string.

Any guidance?
Thanks!