View Single Post
  #6   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Whoops, try

=TEXT(A1,"m/d/y - ")&TEXT(B1,"m/d/y")

In article ,
JE McGimpsey wrote:

one way:

=TEXT(A1,"m/d/yy") & TEXT(B1,"m/d/y")