天气预报15天查询> 生活> excel中如何转化出生日期格式

excel中如何转化出生日期格式

更新时间: 2021-03-22 04:12:02     

日期转换:输入“20110606”时,自动转换为:2011-06-06:

1、首先,选中单元格,

2、然后右键选择“设置单元格格式”,

3、单击左边然后在右边的“类型”中输入“0000-00-00”确定就OK了。

关键词: excel 如何 转化 出生 日期 格式

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-1902287/ | 耗时:0.0977 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1902287 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1902287 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1902287 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1086310,80020,618018,1304733,85957,1129837,1530141,1093825,868217,868347,82099,1793772,1079325,81128,1048004,967470,1095948,1083592,1060383,81806,88487,3527176,3197225,86801,81273,80543,1128633,757069,3513383,3250711) ORDER BY field (ArticleID,1086310,80020,618018,1304733,85957,1129837,1530141,1093825,868217,868347,82099,1793772,1079325,81128,1048004,967470,1095948,1083592,1060383,81806,88487,3527176,3197225,86801,81273,80543,1128633,757069,3513383,3250711)