Keep my date format instead of julian dates

M

MikeMike

I am working in excel with a update for my mysql DB and I have problems with
the date format.

In A1 I have a SKU#10255 and in B1 I have: 8/9/2004
In another field I have: ="UPDATE products_details SET
products_shipment="&"'"&B1&"'"&" WHERE products_model="&"'"&A1&"'"&";"

I want a output like:
UPDATE products_details SET products_shipment='8/9/2004' WHERE
products_model='10255'

but instead I am getting:
UPDATE products_details SET products_shipment='38208' WHERE
products_model='10255'

I know I can go into B1 and type ' in front of the date, but column B has a
lot of dates for each of my SKU numbers.

Anyone know how to fix this?

Regards
Mike
 
J

Jim Rech

Perhaps you can replace the reference to B1 with a formula like this:

TEXT(B1,"m/d/yyyy")

--
Jim Rech
Excel MVP
|I am working in excel with a update for my mysql DB and I have problems
with
| the date format.
|
| In A1 I have a SKU#10255 and in B1 I have: 8/9/2004
| In another field I have: ="UPDATE products_details SET
| products_shipment="&"'"&B1&"'"&" WHERE products_model="&"'"&A1&"'"&";"
|
| I want a output like:
| UPDATE products_details SET products_shipment='8/9/2004' WHERE
| products_model='10255'
|
| but instead I am getting:
| UPDATE products_details SET products_shipment='38208' WHERE
| products_model='10255'
|
| I know I can go into B1 and type ' in front of the date, but column B has
a
| lot of dates for each of my SKU numbers.
|
| Anyone know how to fix this?
|
| Regards
| Mike
|
|
 
Top