How do I export xml file and keep the date.

[Nicholas]

I have a column in my excel sheet that is a date. I am trying to export it
into xml, however, the date is showing up as the excel date number in the xml
file.

Thanks in advance.

 

[David Biddulph]

Have you tried using the TEXT function?

 

[Nicholas]

I have tried that...

Ideally, I would like to be able to enter the date and use the Excel
features of date formatting.

So currently, if I type in the date format, and then convert to text, it
gives me the excel date number as text. I can do cut and paste special into
a pre-formatted text column and get the excel date number as well.

I can manaully type in a text formatted box text that looks like date, but
that I feel just adds to many manual steps to generate an xml file and you
don't get consist formating.

I don't think I am asking for to much..
Thanks

 

[David Biddulph]

I don't understand what you are trying to do with your xml. If you have a
date in column A, the TEXT functuion would give you a text representation of
that date in column B. Can't you use that to generate your xml?