Problem with date format in script

[Brustigian]

I have created in Excel 2010 a worksheet using the script below. The problem is the date format. Sometimes I get the preferred date format example. However most of the time I get the wrong date format. The date data is sourced from column “B” and in this example row “6”. How can I correct the date format issue? Thank you. Bob

Script
=D6&" at "&C6&" on "&B6&" the purpose of call was to "&G6&".

This is an example of the preferred result (note date format)
Visited Tim Sanders at 3001 S. Bristol St, Santa Ana on 12/18/2013 the purpose of call was to discuss referrals.


This is how it often times returns (note wrong date format)
Visited Tim Sanders at 3001 S. Bristol St, Santa Ana on 41683 the purpose of call was to discuss referrals.

 

[General Ledger]

Brustigian,

Maybe this will help,

=D6&" at "&C6&" on "&TEXT(B6,"m/d/yyyy")&" the purpose of call was to "&G6

Best of luck,

GL

 

[Brustigian]

Hi GL, I used your solution and it works perfectly. Thank you so much for helping me. Gratefully, Bob