View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default date time consolidation

Add them together and then give the cell a nice format: mmm dd, yyyy hh:mm:ss



Andrew wrote:

I have two separate cells. One with data one with time. I need to make the
two cells into one with the date and time. Seems simple but.....


--

Dave Peterson