Format(Now(), "mm/dd/yyyy hhmm")

Ed

On Mar 20, 12:20 pm, ExcelMonkey
wrote:
When I use the NOW() function in VBA I get the current format:

3/20/2007 1:20:46 PM

How do I change this to get the following:

3/20/2007 1320

I need to get rid of the colon and lose the seconds.

Actually it would be interesting to know how to extract the formatting
imbedded int that as well. Is their a format property?

Thanks

EM