Not to sure what you mean when you say convert to from date. Convert to what?
You can use the text function to get a date converted to text.

=Text(A1, "yyyy/mm/dd/hh/mm/ss")

As for the leap year issue that is not a bug in XL. It is a bug in Lotus
123. For XL to be compatable it had to make the same mistake as Lotus.
--
HTH...

Jim Thomlinson


"David Thielen" wrote:

Is there any code or an article that lists exactly how to convert to/from a
datetime as stored in an Excel XLSX file and
year/minth/day/hour/minute/second?

Also, from playing with it, it appears that Excel thinks 2/29/1900 existed
(it was not a leap yer).

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm