Excle数据处理:
20200426224902
注:数据坐标如A2, c8,...
=TEXT(数据坐标,"0000!-00!-00 00!:00!:00") 2020-04-26 22:49:02
=TEXT(LEFT(数据坐标,8),"0000!-00!-00") 2020-04-26
=TEXT(mid(数据坐标,9,8),"00!:00!:00") 22:49:02
单元格格式化-自定义: 0-00-00 00!:00!:00 2020-04-26 22:49:02
2020-04-26 22:49:02
=TEXT(数据坐标,"yyyymmddhhmmss") 20200426224902