# XML into Excel - leading zero

**URL:** <https://forum.kirupa.com/t/xml-into-excel-leading-zero/214914>\
**Category:** programming\
**Created:** [February 1, 2007, 10:48pm UTC](https://forum.kirupa.com/t/xml-into-excel-leading-zero/214914 "2007-02-01T22:48:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![DHDesign](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@DHDesign](https://forum.kirupa.com/u/DHDesign)\
**Post date:** [February 1, 2007, 10:48pm UTC](https://forum.kirupa.com/t/xml-into-excel-leading-zero/214914/1 "2007-02-01T22:48:03Z")

</div>

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

```auto

<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!