Date
 

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

Date
 

=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

Date
 

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

Date
 

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

Date
 

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