Excel formatting for date is not working when exporting as XML

I have created an Excel that includes a mapping file. What I am trying to do is have users enter the data in here and press ctrl + E (I created a macro) and it would export it out as XML. Here's the issue: When line 1 gets exported, it keeps its date and time format in XML (Example: In XML, time will show up as 12/01/2013). But anything entered under that line will not show up in the format I want. Instead, it will show up as 1345464 for date.

This thing has been very annoying because I cannot figure out what I can do to format the whole Excel document/column so it will show the date and time as text instead of weird number.

Someone please help me out.

Wow I feel stupid! It was easier than I could have ever thought:

Step1: Drag the date that is in start date to the row you will populate data. (Do the same for Enddate column).

Step2: Notice a small square box at the bottom (it appears after following the step1). Expand the square box.

Step3: Choose the option that says: Fill Formatting Only.

Congrats! Now try to enter/paste a date. It should stay in left (text format).