formula result - HELP - very simple

  • Thread starter Thread starter fishingLarry
  • Start date Start date
F

fishingLarry

I am having a problem with the result of this formula.
=A1&B1&C1&D1&E1&F1&G1&H1&I1
A1 is a date and E1 is a time.
The result displays like this.
A1 E1
39291 - Paradise Band - 0.791666666666667 - Twisted Martini PVB -
280-8800
How do I get it to display the date and time properly?
Thanks
 
Use TEXT to format.

Try it along this line:
=TEXT(A1,"dd-mmm-yyyy")&B1&TEXT(E1,"h:mm AM/PM")&F1&G1&H1&I1&J1&K1
Adapt the format to taste
 
Oops, it should have read:
=TEXT(A1,"dd-mmm-yyyy")&B1&C1&D1&TEXT(E1,"h:mm AM/PM")&F1&G1&H1&I1


---
 
Back
Top