| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining 2 cells
Hello from Steved
I've got a cell with 5:00 I've converted it to 0510 when highlighting the cell it shows 05:10:00. Cell B5 has 4701, Cell C5 has 5:10 please how do I combine the two cells into D5 to look like 47010510 As at the moment I am getting 4710.215277777777778 Thanks for your time |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining text & number from different cells | Excel Discussion (Misc queries) | |||
| Working with Random Text & Combining Cells | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
| Date formatting when combining two cells into one | Excel Worksheet Functions | |||
| combining cells | Excel Discussion (Misc queries) | |||
Threaded Mode
