formula result - HELP - very simple
 

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

formula result - HELP - very simple
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fishingLarry" wrote in message
ups.com...
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

formula result - HELP - very simple
 

Oops, it should have read:
=TEXT(A1,"dd-mmm-yyyy")&B1&C1&D1&TEXT(E1,"h:mm AM/PM")&F1&G1&H1&I1

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

formula result - HELP - very simple
 

Thanks, Max

formula result - HELP - very simple
 

welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"fishingLarry" wrote in message
oups.com...
Thanks, Max