| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Cells
I have 4 cells that I need to combine into one cell. One cell has a
time in it. When I combine cells it does not come up as time but a fraction. A1 8:30 B1 A C1 Cards D1 Indians My formula is =+A1&" "&+B1&" "&+C1&" "&+D1 I get this 0.354166666666667 A Cards Indians I want 8:30 A Cards Indians |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Cells | Excel Discussion (Misc queries) | |||
| Need help with combining cells to one | Excel Discussion (Misc queries) | |||
| combining two cells | Excel Discussion (Misc queries) | |||
| combining cells | Excel Worksheet Functions | |||
| combining cells | Excel Discussion (Misc queries) | |||
Threaded Mode
