| 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 |
| 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 | |||
Threaded Mode
