ActiveCell.Value = Date
ActiveCell.Numberformat = "mm/dd/yyyy"

--
Regards,
Tom Ogilvy

"Tim" wrote in message
...
Hello All,

I would like to convert the date that is generated by
the "Now()" formula in a work sheet to just the text of
the date.

i.e. result in text as 12/01/2004

Thanks in advance