Have excel export cell format other than text; need time and date not number value

[ogibogi]

First thank you for taking the time to read about my problem. Secondly
I'm not an xml or excel hotshot. I can barely write a macro.

My problem is this.
When exporting my xml data, the time/date values lose their readable
format. A time of 01:30 am, for example, becomes something like
0.001353 for example.

What do I need to do to keep the same format as is in Excel? It would
sure be great if you could help.
Kind regards