date time stamp converting to number when used in formula

[ambuj33]

Hello,

I am in a situation where I am making a sql query by using the columns in excel, out of which 1 column contains date time as 2017-06-13 13:18:18 PM and whenever I used this column in formula it reflects as 42899.554375.

="INSERT INTO ORDERS("&A1&","&B1&","&C1&","&D1&","&E1&") VALUES ("&A2&","&B2&",'"&C2&"','"&D2&"','"&E2&"')"

This is the formula I am making where B2 contains date.

Please assist.

TIA
Ambuj S

<tbody>
</tbody>

 

[footoo]

Try this :

="INSERT INTO ORDERS("&A1&","&B1&","&C1&","&D1&","&E1&") VALUES ("&A2&","&TEXT(B2,"yyyy-mm-dd hh:mm:ss AM/PM")&",'"&C2&"','"&D2&"','"&E2&"')"