I am trying to write the date and time to a text file. The cell that is
being read is formatted like this: m/d/yyyy h:mm
When it is written to the text file it looks like this: #2006-08-07
18:51:03#

How can I make it write the correct format to the text file?

IE: #7-8-2006 18:51#


--
clayton
------------------------------------------------------------------------
clayton's Profile: http://www.excelforum.com/member.php...fo&userid=4563
View this thread: http://www.excelforum.com/showthread...hreadid=569248