View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default linking a text with a date and can't remember the format

Well, this works for me, but seems there should be a better way...
=A1 & TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2))," m/d/yy")

P.S. Happy Birthday, Sam. Welcome to the world?? Or is there not really a
Sam? <g


"lauras03" wrote:

I want to link text in a1 "Sam's Birthday is" & a2 "2/17/07 to show in a3.
When I
input in a3: =a1&a2 I get Sam's Birthday is 39130. I know this needs
something like m/d/yy with the A2 but can;t remember what format it needs.

Thanks,
Laura