Problem with Date

  • Thread starter Thread starter Denny
  • Start date Start date
D

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.
 
Denny

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

Tony
 
Back
Top