View Single Post
  #2   Report Post  
Oliver Ferns via OfficeKB.com
 
Posts: n/a
Default

Hi
Try this...

=A1&TEXT(A2,"DD-MM-YYYY")

Cheers,
Oli

--
Message posted via http://www.officekb.com