Date

[Tim]

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

 

[Sharad Naik]

=TEXT(LEFT(NOW(),10),"dd/mm/yyyy")

Sharad

 

[Tom Ogilvy]

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

 

[JE McGimpsey]

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")

 

[Sharad Naik]

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

=TEXT(LEFT(NOW(),10),"dd/mm/yyyy")

Sharad