Problem with Date

[Denny]

Dear all,

I've a problem with date when I input a cell with text and
a date.

I input:
="The profit of selling tickets as at" & NOW()
Return:
=The profit of selling tickets as at 38871.9924....

Please kindly advise how to fix this problem.

Thanks.

 

[acw]

Denny

Try something like
="The profit of selling tickets as at " & TEXT(NOW
(),"dd/mm/yyyy")

Tony