View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Season
 
Posts: n/a
Default how do i combine a date cell and a time cell in excel?

how do i combine the date(A1) and time(B1) to show up in one cell and have
the correct format (C1).

A1 B1 C1
5/25/05 13:00 5/25/05 13:00