Have you tried using the TEXT function?

e.g.

=TEXT(A1,"DD/MM/YYYY HH:MM:SS")

Assuming cell A1 contains date/time entry


--
humejap
------------------------------------------------------------------------
humejap's Profile: http://www.excelforum.com/member.php...fo&userid=5506
View this thread: http://www.excelforum.com/showthread...hreadid=395275