| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
After concatenating data, how do I get Excel to recognise date
Anisette,
you need to tell Excel that you want the (numerical) value of your result, so change your formula to: =VALUE(C1&"/"&B1&"/"&A1) + D1/24 and format the cell as dd/mm/yy hh:mm, then copy down if needed on other rows. You do not need to add the ":00:00". Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Extracting data from the current date | Excel Worksheet Functions | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
