Search code examples
exceldatetimeexcel-2007

DateTime format missing in Excel

I'm facing a problem in Excel which is the date's values are all missing in the cells.

Actual values in database:

ID  Date
001   2015-05-18 00:00:00.000
002   2015-05-22 00:00:00.000
003   2015-05-21 00:00:00.000
004   2015-05-18 00:00:00.000

Excel view (ERROR):

ID  Date
1   00:00.0
2   00:00.0
3   00:00.0
4   00:00.0
Solution

  • Excel doesn't recognize "-" as valid date seperator. You have two options:

    • change your locale to allow "-" as a date seperator
    • convert the "-" to your local date seperator (usually a '.' or "/") when creating / querying the data source