They are coercing text into value as if I were using the function VALUE.

Regards,
KL


"Mangus Pyke" wrote in message
...
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