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#