View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Date in Concatenation

Maybe

=A1&" "&TEXT(A2,"dd:mm:yyyy")&" "&TEXT(A3,"HH:MM")

Mike

"FARAZ QURESHI" wrote:

I have following values in cells
A1=Faraz
A2=(Current Date)
A3=(Current Time)

When I type the formula:
="This file was created by "&A1&" on "&A2&" at "&A3

The result line shows date and time in format of numbers and fractions.

Any help would be highly obliged.

Thanx!