MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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