You need to type =A1&TEXT(B1,"dd/mm/yy") ~ or "mm-dd-yyyy", etc depending how
you want the date displayed

As for the Custom Format it's hh:mm

"Edmundo" wrote:


I want to link the contents of two cells together using &. One is text
the other in a date format but when I do it I get the text and the date
no. not the format it is in in the original cell...help; how do I do
it?

(also what is the custom format setting to turn say 1:30 to 01:30?)

Any help most appreciated.


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