Date Value & Date Format

[Denny Leung]

Dear all,

In a cell, I type a sentence combining text and a date.
However, the date turns out a value instead of current
date.

="The profit of selling tickets as at" & NOW()

Result:

=The profit of selling tickets as at 38871.99423...

Please advise me how to fix this problem.

Thanks.

 

[Dave Peterson]

="the profit...." & text(now(),"mmm dd, yyyy hh:mm:ss")

(change the format to what you like.)

 

[Mike]

="The profit of selling tickets as at "&TEXT(NOW(),"h:m:s")&" on "&TEXT(NOW(),"m/d/yy")