如果单元格格式非文本,可直接右键-单元格格式-数子-自定义-类型 里面选择
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d1599144ee95504fc2d4626952?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如果单元格是文本,可参考以下函数
=VALUE(LEFT(A1,4)&"/"&MID(A1,FIND("年",A1)+1,FIND("月",A1)-FIND("年",A1)-1)&"/"&MID(A1,FIND("月",A1)+1,FIND("日",A1)-FIND("月",A1)-1))
转化为日期
追问那2019年6月5日算是文本还是非文本呢?
追答这得有表单才知道啊,都有可能的
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/86d6277f9e2f07082333e0e6e724b899a901f226?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
比如我这个E4就是“常规”格式的单元格
本回答被提问者采纳