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

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

On Wed, 23 Feb 2011 01:18:06 -0800 (PST), Nicawette <(E-Mail Removed)>
wrote:

>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

Dear Gord,

Thank you, it works

Nice day