FORMAT not working for Date to text as expected

I used to know how to do this, but have been away for too long. I have an Excel 2010 macro I am working on that spits out a fixed field file as it's final output. The file is generated daily and is FTP'ed daily to the client's server. The client wants the format to be INSPECTION2013030154726.TXT. I was using the format function with a format, but the date and time are unchanged from system settings:

Please Login or Register  to view this content.

I am still playing with it, but not remembering how to do it. Any clues?

SOLVED!

Please Login or Register  to view this content.

...should hyave been...

Please Login or Register  to view this content.

That was part of it. Much thanks!

Originally Posted by oeldere

Not sure about it, but you can give it a try.

See the red text.

Please Login or Register  to view this content.