I'm facing a problem in Excel which is the date's values are all missing in the cells.
我在Excel中面临一个问题,即日期的值在单元格中都缺失了。
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):
Excel视图(错误):
ID Date
1 00:00.0
2 00:00.0
3 00:00.0
4 00:00.0
1 个解决方案
#1
0
Excel doesn't recognize "-" as valid date seperator. You have two options:
Excel无法将“ - ”识别为有效日期分隔符。你有两个选择:
- 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
更改您的区域设置以允许“ - ”作为日期分隔符
创建/查询数据源时,将“ - ”转换为本地日期分隔符(通常为“。”或“/”)
#1
0
Excel doesn't recognize "-" as valid date seperator. You have two options:
Excel无法将“ - ”识别为有效日期分隔符。你有两个选择:
- 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
更改您的区域设置以允许“ - ”作为日期分隔符
创建/查询数据源时,将“ - ”转换为本地日期分隔符(通常为“。”或“/”)