Excel dates not formatting correctly

Question

Thank you for reading this question and the attempt you will put into this to help me,appreciate it.

Anyways, i have an excel file that i am trying to get into SQL via import. Everything works fine but when I check excel i see some rows as null where there should be values. (btw my date format in SQL is mdy). So I checked in excel and saw that the dates were a little different so i selected the column and formatted them the same. However i still noticed the same error. Upon further investigation I realize the dates are still different in the fomular bar and the dates formatted as '30-sept-93 (with the little green mark in the corner) come over correctly while those that look like 5/7/1993.

I was wondering if there was some way or macro that i can change all those dates to ACTUALLY be like this correct rather than just looking right and breaking in SQL Correct results vs wrong one

Formatting will indeed only change the appearance of your data, not change the actual input. — Terry
– Terry, Commented Jan 16, 2014 at 12:39

MPelletier · Accepted Answer · 2014-01-16 13:04:19Z

1

Try using =DATEVALUE(TEXT(A1,"DD-MMM-YYYY")) function on that column.

edited Jan 16, 2014 at 13:04

MPelletier

16.8k18 gold badges91 silver badges140 bronze badges

answered Jan 16, 2014 at 12:39

Taosique

7,9143 gold badges33 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel dates not formatting correctly

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related