天气预报 > 生活 > excel中如何转化出生日期格式
excel中如何转化出生日期格式
更新时间: 2021-03-22 04:12:02  

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

1、首先,选中单元格,

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

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

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

excel中如何转化出生日期格式相关经验

天气预报

最新推荐

页面:/news/view-1902287/ | 耗时:0.5610 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
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)