Merge cells time format

  • Thread starter Thread starter Arne Hegefors
  • Start date Start date
A

Arne Hegefors

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!
 
The OP (whose question you snipped) didn't want text, but wanted an Excel
date and time.
He needs =A1+B1, appropriately formatted.
 
Back
Top