Formula to get date field in Excel sheet SQL Server query

I have data in Excel sheet and I need to update SQL Server DB table by using Excel sheet data, I am able to write SQL Server Query and get the data. However I am not getting date field in date format, it’s rendered as a normal number.

Answer

In cell B2 try this –

="Select " & TEXT(A2,"DD/MM/YYYY")