sufianmalik
Board Regular
- Joined
- May 7, 2002
- Messages
- 128
Hi there
i have two workbooks. i need to copy a date cell from one workbook to another and after the date append the time.
whats the easiest way to append the time to the end. for example in A1 date says 30/03/2009, in destination cell would like 30/03/2009 17:00
Thanks for your help
Sufian
i have two workbooks. i need to copy a date cell from one workbook to another and after the date append the time.
whats the easiest way to append the time to the end. for example in A1 date says 30/03/2009, in destination cell would like 30/03/2009 17:00
Thanks for your help
Sufian