MrExcel Publishing
Your One Stop for Excel Tips & Solutions

convert to date 08/10/01


Posted by Shmaya Friedlander on August 10, 2001 7:41 AM

if I tri to enter this message in one cell
="today : " &TODAY()
the result is: today : 37113
how can i get the right result : Today : 08/10/01


Posted by Barrie Davidson on August 10, 2001 7:43 AM

Use
="today : " & Text(TODAY(),"mm/dd/yy")

Barrie

Posted by Mark W. on August 10, 2001 7:43 AM

="today : " &TEXT(TODAY(),"mm/dd/yy")