Not sure why you need text - you could just use

=TODAY()

and format it with Format/Cells/Date.

However, if you want it as text, use

=TEXT(TODAY(),"mm/dd/yyyy")




In article ,
"Tim" wrote:

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