show date in proper format

[Mosaddeq Aziz]

hi,

If i enter this formula "Date: " & today()

it shows Date in digit value i.e. Date: 40042.

I want it to show Date: 17/08/2009

How?

Mosaddeq

 

[JP Ronse]

Try

="Date: " & TEXT(TODAY();"dd/mm/yyyy")

Wkr,

JP

 

[Mosaddeq Aziz]

thanks. works perfect.

Try

="Date: " & TEXT(TODAY();"dd/mm/yyyy")

Wkr,

JP

 

[JP Ronse]

you're welcome

thanks. works perfect.

 

[norie]

Why not just use a custom format?

"Date: "dd/mm/yyyy

 

[JP Ronse]

You are right , is also working.

Wkr,

JP