View Single Post
  #3   Report Post  
Edmundo
 
Posts: n/a
Default


Done it;

=A1&", "&TEXT(A2, "d-mmm-yy")

still stuck on turning 24 hour clock times 00 to 09: from eg 1:30 to
01:30 without eg 023:30


--
Edmundo
------------------------------------------------------------------------
Edmundo's Profile: http://www.excelforum.com/member.php...o&userid=24837
View this thread: http://www.excelforum.com/showthread...hreadid=383873