On Sat, 30 Jul 2005 02:14:45 +0200, "KL" wrote:
This formula works for me:

=--(TEXT(A1,"0000-00-00 00\:00"))

Don't forget to format the cell as date.

KL- What are the two hyphens for at the beginning of this formula?

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner