Is there any way to display test and the NOW() function in a single cell? I have tried using concatenate or simply & in a formula, but NOW() displays as a number rather than a date. The goal is for a single cell to display what is shown in cells B2 and C2 of the attached sheet.
change the formula to this... =CONCATENATE("CURRENT DATE AND TIME: ",TEXT(NOW(),"m/d/yyyy"))
if you want to also show the time, make it this way... =CONCATENATE("CURRENT DATE AND TIME: ",TEXT(NOW(),"m/d/yyyy hh:mm"))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Works like a charm. Thanks!
You're welcome, glad I could help, AND thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks