formula result - HELP - very simple

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
 
M

Max

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
 
M

Max

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


---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste formulas in merged cells 2
How do i average only certain cells 5
Nested IF statement 3
How to count date difference in excel? 5
Lookup 10
How to copy the function SUM but offseted in 7 columns 2
Empty cells 1
Multiple if condition formula required 4

Top