Hi! In column A I have dates eg 2008-05-06. The format of the cells is date
also (excel sees the column as proper dates). In column B I have time eg
11:43:10. The format of those cells is time (excel also sees them as proper
time stamps). Now I want to combine the values in column A with column B. The
result is supposed to be a date and a time stamp in the same cell eg
2008-05-06 11:43:10. I tried simply to merge A and B in column C by writing:
=A1&" "B18 (i have tried without the blank space also). But I cannot get
Excel to understand that they are date and times ie the format is not working
properly in column C. what can I do to fix it? I tried to copy the results
and then paste special (pasting only the values) and then chnaging format.
any help appreciated!