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