| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
day and time concatenate
I have days stored in a column, and dates associated to them in other. Whe I
try to concatenate them in a single cell, the numbers are converted and I get something like this: day time concatenate 2007- 02-15 0.00 19322 I've tried formatting in different ways the cells involved, without success Any suggestion? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to concatenate date and time? | Excel Discussion (Misc queries) | |||
| Concatenate/Time Functions | Excel Worksheet Functions | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| How to Concatenate Time with some operator? | Excel Worksheet Functions | |||
Threaded Mode
