| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula result - HELP - very simple
Thanks, Max
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula result - HELP - very simple
welcome
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "fishingLarry" wrote in message oups.com... Thanks, Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strange and inconsistent result from a simple formula | Excel Worksheet Functions | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
