Only
=TEXT(NOW(),"dd/mm/yyyy")
should do.

"Sharad Naik" wrote in message
...
=TEXT(LEFT(NOW(),10),"dd/mm/yyyy")

Sharad

"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