fkjj.net
当前位置:首页 >> 170501 2017 >>

170501 2017

Sub tttt() ActiveCell.NumberFormat = "yyyy/mm/dd" End Sub

Cells(1, 1) = Left(Cells(1, 1), 2) & "-" & Mid(Cells(1, 1), 3, 2) & "-" & Right(Cells(1, 1), 2) Cells(1, 1) = Format(Cells(1, 1), "yyyy/mm/dd")

网站首页 | 网站地图
All rights reserved Powered by www.fkjj.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com