convert to date 08/10/01
Posted by Shmaya Friedlander on August 10, 2001 7:42 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 faster on August 10, 2001 7:51 AM
goto format cells and make a custom format like:
"Today "mm/dd/yyyy
then type date into cell
Posted by Ryan on August 10, 2001 8:19 AM
TYPE THIS INSTEAD:
="TODAY: " & TEXT(NOW(),"mm/dd/yy")
