date conversion

[aivoryuk]

i have 2 columns

<TABLE style="WIDTH: 125pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=167 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" align=right width=64 height=20>3851337</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 77pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right width=103>15/11/2010</TD></TR></TBODY></TABLE>

I ma using the following to create a text string so that I can insert rows into SQL.
="INSERT INTO #tmp VALUES('"&A4&"','"&B4&"')"

the problem I am getting is am getting a numeric value for the date when what I want is the date in the same format as the B column (it is a UK date)

Any ideas?

 

[syntaxed]

Maybe:
="INSERT INTO #tmp VALUES('"&A4&"','"&TEXT(B4,"dd/mm/yyyy")&"')"

 

[aivoryuk]

Maybe:
="INSERT INTO #tmp VALUES('"&A4&"','"&TEXT(B4,"dd/mm/yyyy")&"')"

lovely thanks for your help I had thought of a text conversion but would not thought of that.

regards