date format in excel imported from an SQL DB.

[Nicawette]

Dear all,

In a table, I have a column with a list of date.
These dates are imported in a excel spreadsheet table via an SQL query
linked to a SQL server (like Table1_data[[#This Row],[Date]]) , and
the data in the DB are in date format.
But excel does not recognize the date unless I enter into the cell and
I hit enter.

e.g.
2009-09-01 = 2009-09-01
but when I hit enter
2009-09-01 = 40057 (excel date format)

Any hint to avoid this manual intervention as I have thousands of
dates :-(

Tx

Nico

 

[Gord Dibben]

Select the column(s) of dates.

Data>Text to columns>Enter usually does the trick.

If not, go a couple steps further and select Date for column data format.


Gord Dibben MS Excel MVP

 

[Nicawette]

Dear Gord,

Thank you, it works

Nice day