Date in Concatenation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
="This file was created by "&A1&" on "&TEXT(A2,"mm/dd/yyyy at ")&TEXT(A3,"
hh:mm:ss")



Gord Dibben MS Excel MVP
 
Back
Top