XML into Excel - leading zero
i have an XML file with both strings & numbers such as (part of the XML):
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.
"First time it's a mistake, do it again and it's stupidity."